Multiple Records on a Single Screen

[J]

I have a form that displays Project numbers at the top of the form and
displays information about that project number below. It is possible
that a Project Number can be there more than once on a form. My
problem is being able to get it so that all the information regarding a
particular Project Number appears all on one screen rather than
appearing randomly throughout the records.

For Example:

Right now my form displays like this:

A01
Information Here

A02(New Record)
Information Here

A01(New Record)
Information Here

But I want it to display like this:

A01
All information on A01 here

A02(new screen)
All information on A02 here

A03(new screen)
All information on A03 Here

etc.

 

[Guest]

J;
It appears that you're basing your form directly on the table. Try basing it
on a Query or SQL statement, where the records are sorted and grouped based
on Proj ID.
Given how you've outlined your data (where multiple records contain data for
a single project), you'll likely have to use a UNION SELECT query to combine
the multiple records into one for each project.

Alternatively, you could also use a sub-form that contains all the project
data and have it linked to the main form by Proj ID. This will display in the
sub-form the proj info for any given project displayed on your main form.

 

[J]

Something else that I was wondering as well is that if I use a query,
where would I insert this query to be used (ex. form, subform, etc).
Also, I am not very familiar with Union Select queries and was
wondering how they function.