On one form, I need to open another form using a button. The catch is that the code must check whether a record has been created with that Project_ID. If it has, then it must display that record. If not then it must make a new record.
The db is attached. The button is called "Form 1" on the "Contract Details" tab of frm_Project_Details.
I need it to make a new record in tblContract_Record using frm_ContractRec_Details or, if the record already exists, then open that record.
I have searched this forum, trawled the net, and tried many things and hit many frustrating dead ends. It can't be that difficult, surely!