Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002

    Unanswered: Strange behavior of subforms

    I have a form with a subform.
    The content of the subform was related to the value of a combobox (= employeeID of the selected person).
    This all worked fine.

    Now it's not working anymore and I can't find any reason.
    I changed the query (= recordsource of my subform) so it no longer depends on the value of the combobox. I'm 100% sure I must have 3 records in my subform. My sub still stays empty.
    I deleted and re-inserted the sub in my form --> no difference.
    I made a new form and inserted the sub --> it works.
    Why does it work fine on one form and doesn't on another ?

    I'm getting depressed, so if anyone has any idea?

  2. #2
    Join Date
    Jan 2003
    Rockville, MD
    Anything goofy in the "Link Child Fields" or "Link Master Fields" properties of the sub-form control?

  3. #3
    Join Date
    Dec 2002
    Préverenges, Switzerland
    try deleting the sub, compact & repair, and drag the sub back in again.

    wierd things happen when lots of edits accumulate in the mdb: it's not a bad idea to compact & repair regularly when you are coding - helps to tell your mistakes from mr. gates' mistakes.


Posting Permissions

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