duplicate values

[srn]

Hi. My database records patient attendance on a daily basis. I have one form
to record patient number and it automatically records date and time, and
saves this info to an attendance table. I would like a message box to pop up
if the same patient number is re-entered on the same day i.e. to check the
attendance form for both the patient number and the date. If they are both
true then warn the user, and gve an option to continue to enter data - since
some patients can attend more than once, or cancel.
Regards stuart

 

[Ken Warthen]

SRN,

Does your form have a command button that must be clicked to write the
patient information to the attendance table? IF so, you can add some code to
the on_click event procedure to check the attendance table for the entered
patient number and current date.

 

[srn]

The IDsurname code is entered, this triggers date and time to be recorded
direct from the PC, I tab to a field recording another number and then click
on a command button to record the info to the attendance table. The newly
added record is then displayed along with all the other records for that day