Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007

    Question Unanswered: Subform of a Subform disappears on record change

    Hi All,
    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.

  2. #2
    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! 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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts