I am having problems requerying two subforms from one main form but not the second.
I have two intake forms - one for entering New family information and a second for Updating family Information.
They both use the same subforms, family members and pickup family, no data is entered directly in the subforms, they are added, updated and deleted using a button and other dialog forms.
All forms and subforms and add or update/delete forms are working fine and the underlying tables are being updated etc. In fact the database is working great except I have a pesky problem:-
The New family form won't show ANY data in the family members and pickup family subforms EVEN though the data is correctly entered and saved and is correctly using in the calculations for saving the record. Update Family form works fine with same subforms - displays info correctly when family selected and after adds or updates/changes.
Using some of the excellent information I have found on this site and others I have tried several alternatives of addressing the subform.
I have tried the requery in all sorts of forms from the Add New form which works fine on the Update Form.
I have also tried changing the recordsource of the subform using Me!subformname.Form.RecordSource and several other combinations.
I have tried just displaying the whole table and various SELECT SQL strings - not getting ANY errors but no data EVER appears in the subforms.
During my investigations - I have even tried to
Take a copy of the Update Form and remove the search combo and get it to work.
Open the New Form on the first record instead of on a New record,
EVEN these options don't reveal ANYTHING in the subforms.
Would really appreciate any help/suggestions.
I have two intake forms - one for entering New family information and a second for Updating family Information.
They both use the same subforms, family members and pickup family, no data is entered directly in the subforms, they are added, updated and deleted using a button and other dialog forms.
All forms and subforms and add or update/delete forms are working fine and the underlying tables are being updated etc. In fact the database is working great except I have a pesky problem:-
The New family form won't show ANY data in the family members and pickup family subforms EVEN though the data is correctly entered and saved and is correctly using in the calculations for saving the record. Update Family form works fine with same subforms - displays info correctly when family selected and after adds or updates/changes.
Using some of the excellent information I have found on this site and others I have tried several alternatives of addressing the subform.
I have tried the requery in all sorts of forms from the Add New form which works fine on the Update Form.
I have also tried changing the recordsource of the subform using Me!subformname.Form.RecordSource and several other combinations.
I have tried just displaying the whole table and various SELECT SQL strings - not getting ANY errors but no data EVER appears in the subforms.
During my investigations - I have even tried to
Take a copy of the Update Form and remove the search combo and get it to work.
Open the New Form on the first record instead of on a New record,
EVEN these options don't reveal ANYTHING in the subforms.
Would really appreciate any help/suggestions.
