Please suggest how to autofill data entry form that shows only a blank record. The following code works great when 'data entry' is set to false but fails when data entry is set to true. Here what I've tried: http://allenbrowne.com/ser-24.html
I would like the user to type a unique patient indentifier into a text box on a form and Access would return the rest of the fields for the most recent record for that patient. This would be very simular to search, however, the user would be able to modify and save this information as a new record.
Do I need to query the table to find the last record based on a search criteria?
Thanks
I would like the user to type a unique patient indentifier into a text box on a form and Access would return the rest of the fields for the most recent record for that patient. This would be very simular to search, however, the user would be able to modify and save this information as a new record.
Do I need to query the table to find the last record based on a search criteria?
Thanks
Last edited: