searching and viewing records in forms and maybe updating them?

[jyrixx]

here's my question. i'm making a patient database for a doctor. I want to be able to type a social security number into a text box and be able to view all of the information about that person. how can i do this?

i have a form setup and can input information into it. and would also like to be able to change information or, rather,"update" information in that fashion, using the form. can i do this without it making a new record?

 

[Soundsmith]

You might try this:
Create the form with the patient table as the bound data. Make the SSN an unbound text box. Assign an AfterUpdate event to the SSN control to seek the matching patient record and move to that record (you might also want to make the SSN control a combo box, if an unknown SSN is entered, you can ask if this is to be a new record...)

Once the record has been located, the data are by default editable.

NOTE: This is a VERY simplistic method, and not recommended if this is to be a multi-user system. Also, typically medical record systems are created with a number of linked tables (patient bio, insurance, visits, tests, finances, etc.) This is a fairly ambitious project for Access, and requires LOTS of pre-planning.

Good luck, and I hope this helps.
David 'Dasher' Kempton
The Soundsmith

http://www.thesoundsmith.com

 

[jyrixx]

hey, thanks
yeah.. i've realized the planning. it is a single user system, so i'll try that. thanks for the help