Subform problem

  • Thread starter Thread starter Rog
  • Start date Start date
R

Rog

I have a form with a subform. The main form is base on a
table. The subform is base on a query of 2 tables one of
them is the same table as the main form is using. I also
have 2 comboboxes on the subform.
I am suppose to put in information on the main form tab
down to the subform select an item in the first combobox,
the second combobox is filled from a choice of the first
combobox.
What is happening is when I open the form I am requested
to input a value for the first combobox, then the form
opens. After I input the information on the main form and
tab down to the subform and choose the first combobox I am
again requested to input a value before I can actually get
the name I want in the first combobox. What is going on?
I can I fix this problem? Thanks for any help
 
i use subforms a lot, and may be able to help if i can see
your db. if you'd like me to look at it, copy the db,
remove proprietary data (put a least a couple fake records
in tables), compact, zip if necessary to reduce to 1 MB or
less, and email to me. i'll see if i can fix it, and
return it to you.
 
Back
Top