Custom numbering records in a subform

  • Thread starter Thread starter Adriana
  • Start date Start date
A

Adriana

I have a continuous form that lists current projects based on a main table
that has a subtable of the project elements (the details of the main project
name and number). When a project is created in the form, project details are
also assigned (could be several) and another form shows open projects. The
problem is that if the main project has a few project details, the main
project name shows up several times based on how many details there are.
This can be confusing to the users to where they think there are more main
projects than they think they have when it's really just one main project
with element details (sub tasks).

How do I make the form either show the main project once with details listed
separately or create a custom numbering system there the main project
autonumber will display as Project Number 1A, 1B, 1C, and so forth?
 
If you have a main form that holds "project" info, and a subform that holds
project-detail info, why are you displaying the "project" on the subform?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top