Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    28

    Question Unanswered: Keep combo value

    Hi have 2 forms a main form and a sub form. The main form has 2 unbound combo boxes. call it box1 and box2.

    What I am trying to do is filter a combo box in the sub form based on the values picked from box1 and box2 from the main form. I have been using the standard =[Forms]![MainForm]![Subform].[Form]![Value] behind the record source of the combo box on the sub form.

    However, this seems to work for the first record in the subform. when I try to select another value for record 2.

    Record 1 A) disapers if it does not match the values of either combo box 1 or 2 from the main form

    B) If I use me.refresh on the form. all of the values dissaper even though they are added into the tabe.

    Can you help???

    Thanks in advance

  2. #2
    Join Date
    Aug 2002
    Location
    Charlotte NC
    Posts
    665
    Its all about where you put the code. It needs to be in the on focus event for it to work right all the time. Give that a try
    Jim

  3. #3
    Join Date
    Aug 2002
    Posts
    28
    Originally posted by JDionne
    Its all about where you put the code. It needs to be in the on focus event for it to work right all the time. Give that a try
    Jim
    Thanks for your help Jim. I will give it a try

Posting Permissions

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