Populating form with previous data

[Will04]

Hi Everyone,

I need some help with this problem.

I have a form with which I enter patient info. Patient will normally visit once per year. When a patient visits, I would like to enter the patient's ID on the form and then search the DB for an existing record.

If the patient already exists, then I would like to populate the form with the previous data, make necessary changes to the data and save as a new record.

If there is no previous record of the patient, then allow the patient data will be entered on the blank data entry form.

Thank you

Will

 

[ColinEssex]

Hi. Have a search for "quicksearch". You will find a sample Db I posted.
It's a Db I posted in A2000 that allows you to search on numerous fields and display the data.

You'll need to tweak it about to reflect your own field names etc.

Col