Unusual combo box behavior

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

I have several sub forms that contain a date field and
several associated data fields. I co located the sub
formes into one main form with a "tab" form set up
seperating the different sub formes. I placed a combo box
on the form and, through the wizard, asked it to find a
record on my form based on the value placed in the combo
box. Each sub form has its own "search" combo box. Alone,
the combo boxes on the sub forms work fine, but on the
combined form the combo boxes seem to be locked (I can
not enter a value, the drop down lists the different date
values for each saved record, but clicking on it does
nothing) until I move my mouse cursor to the "next
record" navigation button and click. Once the 2nd record
is displayed on the form, it seems to unlock the combo
box and then I can enter/select values as normal. I dont
understand why this is occuring. Also, If I make an
adjustment on a form in the design view of the "Combined
Form" (the form that contains the several subforms), I
often get asked if I want to save all changes to all of
the sub forms, even though I only made a change to one of
the sub forms...Is there a property setting I
inadvertantly changed that is causing the forms to act
like this?
TIA
Antonio
 
The lookup combo box should be at the base level of the main form and not
directly at the subform level. If you place the combo box at the subform
level you can't search for anything in that would be in the main form.

Hope this helps.
 
Back
Top