I have a form that multiple people use - i need to isolate them from each other, so DoCmd.GoToRecord =acLast is not an option because the last record may not have been their record....
if they open the form and begin entry and close the form .. then reopen the form to continue entry it creates a 2nd master record id for that person for that same date.
The form has a subform with detail records. I need for them to be able to continue adding the detail records without creating a second master record.
When they open the form, the first 2 fields are - their name (nameid) and Date (date()) - i would like to be able to query the table for an existing record for that person on that date and, if found, retrieve it so they can continue their entry of detail records attached to the previously created master.
can i do this OnLoad with a DLast expression ? or can i use a Select record where NameID = Name & Date = Date() on error New?
I don't know how to do what i need to do ... please Help.
if they open the form and begin entry and close the form .. then reopen the form to continue entry it creates a 2nd master record id for that person for that same date.
The form has a subform with detail records. I need for them to be able to continue adding the detail records without creating a second master record.
When they open the form, the first 2 fields are - their name (nameid) and Date (date()) - i would like to be able to query the table for an existing record for that person on that date and, if found, retrieve it so they can continue their entry of detail records attached to the previously created master.
can i do this OnLoad with a DLast expression ? or can i use a Select record where NameID = Name & Date = Date() on error New?
I don't know how to do what i need to do ... please Help.