cbo on subform

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I have a situation in which a subform appears when a record is selected from
a listbox on the main form. But, a cbo on the subform does not fill based on
the record selected. The query that is used to fill the cbo does work when
tested as it does return the correct information. What I need is for it to
work when the record is selected from the listbox on the main form. Can
anyone help out regarding this?
Thanks.
John
 
try requerying the combobox control on the subform in the mainform listbox
control's AfterUpdate event, as

Me!NameOfSubformInMainForm.Form!NameOfCbo.Requery

hth
 
tina, thanks. it worked.
john


tina said:
try requerying the combobox control on the subform in the mainform listbox
control's AfterUpdate event, as

Me!NameOfSubformInMainForm.Form!NameOfCbo.Requery

hth
Click to expand...
 
Back
Top