Hello all,
I am having a few problems with my database. I have a form (frmCane2) in which the user enters information then clicks a button (butLabNotes) to open another form (frmLabnotes)to enter more information. At the bottom of frmLabnotes is a button (butClose) to close the form and return to frmCane2.
What I want butLabNotes to do is to check to see if a record for the sample (entered in frmCane2) already exists. If it does then I want the frmLabNotes to open with that record showing, otherwise I want the form to open to a new record.
This is so that if someone is entering data into frmLabNotes, closes the form, and realizes they forgot to enter something or entered something wrong, then they can just click the button to edit the information. I do not want frmLabNotes to save a new record each time the button is pressed. Only when one did not exist previously.
Thanks,
Bill
I am having a few problems with my database. I have a form (frmCane2) in which the user enters information then clicks a button (butLabNotes) to open another form (frmLabnotes)to enter more information. At the bottom of frmLabnotes is a button (butClose) to close the form and return to frmCane2.
What I want butLabNotes to do is to check to see if a record for the sample (entered in frmCane2) already exists. If it does then I want the frmLabNotes to open with that record showing, otherwise I want the form to open to a new record.
This is so that if someone is entering data into frmLabNotes, closes the form, and realizes they forgot to enter something or entered something wrong, then they can just click the button to edit the information. I do not want frmLabNotes to save a new record each time the button is pressed. Only when one did not exist previously.
Thanks,
Bill