I don't know if this is the correct approach, but this is the idea
I've got:

A form will have a few controls to enter some data and two buttons.

One button is "Enter as New Record" - this one opens a subform for the
table with the initial data entered in as a new record and the other
fields available for data entry.

The other button is "Find Matching Record" - this one creates a
variable to go into a SELECT statement to search the table for a
record that matches the entered data, and then opens a subform to show
that record and other fields for data entry.

In playing around with this unsuccessfully, I noticed that the
CommandButton wizard has a preset function to go to the new record
field.  It seems to want to go to the new record field of the form's
record source, though.  But the form is built on a query to the table,
right?  So I would have to direct it to the new record field of the
table, and enter the data in the form into the appropriate fields.

I have a sample database for the SELECT code, and I think I can make
that work.  But that will return my data as a query result, right?  I
would need to pull up this record because I have more data to enter,
so I need to show it in a data entry subform based on the table so I
have the additonal fields, yes?

Can someone venture to drop-kick me in the proper direction?  By
chance is there a tutorial or a sample database that I can look at for
this?

Ed