Expanding a form's data fields

[hertfordkc]

Main form based on one table, 5 or so subforms for other tables. I've had a design goal (since 2003) of presenting commonly needed data on one screen/page. The one page printout caved a several years ago.
With the most recent request for additional functionality, I have created several new subforms which display a subset of all of the data in the tables behind them. I've tried to present a pop-up, all data fields view for adding and editing records in the underlying table, but it comes up blank. I assume this is because the table is locked with the sub-form's query. There has to be a simple way to do this, but right now I'm heading toward massive property modification of the sub-form.
Please help "The Elder" find the needed reference/example. I'm flunking my dementia test.


Thanks.
Hertfordkc

[orange]

You may get more responses if you show your tables and relationships.

[hertfordkc]

PersonalData (Acctno, name, address, phone.......)
Payhistory(Acctno, Assessment, Paydate, Payment, ....)
Financial(Acctno, lots, utilities)
SwimTags(Acctno, Tag#, SwimmerName, contact, contact Phone.....)
.....................................
The tables are linked on acctno.
In the main form, all of the data from the personal data is displayed. Some of the subforms displayed the applicable records, i.e. linked on acctno, containing all fields in the underlying table. However, for the swim tags, I'd like to display only the Tag# and Swimmer Name in a non-editable subform. If a user wants to see all of the details of the swimmer records for the account, or to edit or add a record, he clicks on the subform caption and the entire, editable detail should appear.
The expanded form comes up empty. None of the appropriate records appear. Is that happening because the subform has locked the underlying table? (The other subforms do not expand the underlying table.)
Any workaround or suggestion would be appreciated.
Hertfordkc

[hertfordkc]

Thanks, Orange, for your suggestion.

[boblarson]

What is the primary key of PayHistory for example? Or Financial? It doesn't look like you have one. Acctno needs to be the FOREIGN key in the 3 other tables from PersonalData.

[hertfordkc]

Bob,
Perhaps I've missed a fundamental point in keys, but each of the tables is defined and includes an ACCTNO field. In "Table Relationships", the ACCTNO is linked between the tables.
I believe that ACCTNO in the Personal Data table was defined as a primary key in earlier versions of Access, but, if it was, the definition was lost when importing to Access 07.
Thank you for any advice, suggestions or critique.
Hertfordkc

[boblarson]

The ACCTNO right as it is can't be the primary key in the other 3 tables or else you can only have ONE record EVER for an ACCTNO in the 3 other tables.