search and fill in fields based on one field

[kbrooks]

I have a database for patient information for use when our regular system is down. It assigns a "downtime" account number, and the user enters in all other information.

Currently for them to go back and edit a record, they need to scroll through all existing records looking for a specific patient.

I'm hoping to put in a field where they can enter the account number, and it brings up that particular record. Am I asking for too much? And if it's possible, is it relatively simple?

Thanks much for any input!

 

[helena]

Hi kbrooks

Display the account number on the form and use Access built-in search facility to search for the account number. You could also use this to search for any fields displayed on the form eg surname etc. A quick way of bring the search facility up is Ctrl+F.

HTH

Helena