How to Partially Populate New Record

[Duck]

I have database which allows us to look up patient records using a
search form that I type in the patient last name, and first name,
click a button and another form opens up with the complete patient
record.

What I would like to do is to be able to do is if the patient does not
already exist in our database (after typing in the first and last
names) to open up a blank patient record form, ready to input a new
record for the non-existant patient, and already have the first and
last names filled in from the search form on the new patient record
input form.

 

[Arvin Meyer MVP]

Assuming that the form uses a combo box to look up the person, you can use
the NotInList event, like:

http://www.accessmvp.com/Arvin/NotInListDemo.zip