The login form (#1) is used to log in water sample info
and the login code is the primary key. From this form (#1)
the user can choose from 4 different options (forms)(#2)
depending on what type of entity is submitting the water
sample. I'd like to attach a macro to each of the 4
command buttons for the 4 entities that will open the
appropriate form (#2)for the entity chosen. My login form
(#1) will have numerous lab code #s, so I'll have the
inputter check a Yes/No checkbox, run a query based on
the "yes" checkboxes, and the query results will populate
the fields in the form (#2) that was chosen for the
I believe the query would be an update query. It will be
based on Yes using the Yes/No field.
The relationship of the data on the two forms is that it
would be the same data. The login form (#1) will have more
information on it than what is needed for form #2).
Am I way off?
examples, of what you
Query or an
Yes/No field is
shown on the two