A code that will tell me if a record alreadya exist or not.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, there could anybody help me to my problem. I dont know how to make a code
that will tell me if the record is already existing or not if it is existing
then a it will display that specific record that i type the badge number else
it will just go to the textbox ready to accept the new data.

I hope anybody could help me with this regard. Im just a beginner in access
but has well verse in different programming language.

Thanks
Kenji.
 
Add a combo box to your form and use the wizard to "Find a record on my form
based on a value I type". The wizard will create all the code to find the
record for you. When you run your form and type a badge number, if it
exists, your form will jump to that record. If you design the combo box and
set the "Limit to List" property to "True", you can then program it to tell
the user when the badge number does not exist and give them the opportunity
to go to a new record and add it.
 
Back
Top