query from either of 2 forms

[glanvilf]

Have 2 forms, 1 for original data entry (a), 1 to resume entry to a specific
record (b). Each then needs to allow user to go to the same 2nd form (c).
How do I write the query for form (c) to allow it to choose from either form
A or form B as the record source?

 

[John W. Vinson]

Have 2 forms, 1 for original data entry (a), 1 to resume entry to a specific
record (b). Each then needs to allow user to go to the same 2nd form (c).
How do I write the query for form (c) to allow it to choose from either form
A or form B as the record source?

Since a Recordsource must be either a query or a table, and *cannot* possibly
be a form, your question has no answer!

I cannot see why you need three forms: one should be plenty. A single form can
be used for either entering new records or editing existing ones (just be sure
the Data Entry property is set to No), and you can adjust the Filter property
of a form to display specific records. Perhaps these forms differ in other
ways; if so then please explain.

 

[glanvilf]

The forms are being used to record data from medical research and each
contain diagrams/layouts of human body systems. The users click on the
appropriate area in order to enter data about that area. The diagrams have
to be fairly large in order to select between various points, so I can't put
more than one on a form page. Also to have more than one on a single form
could lead to increased errors on the part of those doing the entry, since
there are different data points for similar but different parts of the body
(like different areas of the lungs).

 

[John W. Vinson]

The forms are being used to record data from medical research and each
contain diagrams/layouts of human body systems. The users click on the
appropriate area in order to enter data about that area. The diagrams have
to be fairly large in order to select between various points, so I can't put
more than one on a form page. Also to have more than one on a single form
could lead to increased errors on the part of those doing the entry, since
there are different data points for similar but different parts of the body
(like different areas of the lungs).

Interesting. Have you tried using a single form with a Tab Control? This would
let you display multiple "pages", each with its own graphics and controls.