Checking for existing records before data inputting

N

Natalie

Hi - I have a form containing details of students. Each
student has a unique field called "Student Number". I
want to be able to type in a students number into an
unbound control on a different form, then get access to
search my database. If the student already exists I want
it to open the main form on this record, otherwise I want
it to open the main form on a blank record with the Number
already in the Student Number box.

Could anyone tell me the code i would need to enable this
to happen - thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top