Auto-Fill text fields in the form

[sk88]

is there a way to have a form set to either auto populate fields based on the FIRST FIELD? For example: if the user type in the STUDY ID, the other fields like (first name, last name etc..) are auto-populated/auto-filled?


and if the STUDY ID is new and not in the table, then the users simply fill in all the fields/complete the form and save?

And I would also like a message box to show when I am typing the STUDY ID that would say something like: this person is on the system already. Click YES for this person and NO to add the user?...



does any one have any idea how I should go about doing this?



Thanks!

[NTC]

fundamentally you are seeking a dropdown box placed into the header of a form; and that the form is bound to a table. the wizard will launch when you add the dropdown box and one of the choices is to find/go to a record.

everyone designing an Access database should invest in a textbook easily found at Amazon or any large bookstore.

[sk88]

Sorry, I should have mentioned that earlier that I know how to use the dropdown menu for auto fill but what I am asking is from the simple text field where when I am typing, it will simply populate the field and rest of the fields. Plus those fields cannot be unbound because I would need to save the data to the table.

This is where I am confused.

Thanks