11-13-07, 13:59 #1Registered User
- Join Date
- Nov 2007
Unanswered: Subform of a Subform disappears on record change
I have a tabbed form that that has a subform on it which has a sub form nested on it. So in other words my set up is TabForm -> SubformA -> SubformA_a.
SubformA and SubformA_a both have combo boxes on them. The two subforms are linked by a autonumber field on SubformA. Both forms are for data entry.
The issue is, if I add a record to SubformA and then add multiple records to SubformA_a, when I change Customers (by changing records on my main form) SubformA disappears and I am left with only SubformA_a on the tabbed form.
Any help would be greatly appreciated.
11-13-07, 15:04 #2Moderator
- Join Date
- Dec 2004
- Madison, WI
Sounds like you might have something wrong with the link or how the subform's setup but you can issue a Forms!MyFormName!MySubFormName.requery (or Forms!MyFormName!MySubFormName!MySubSubFormName.re query or me.SubFormName.requery) command in the OnCurrent event of your first sub form or main form.
If the requery command fails to give you records, look at how the setup is on the subform.Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)