cbo on subform

[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

 

[tina]

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

Me!NameOfSubformInMainForm.Form!NameOfCbo.Requery

hth

 

[JohnE]

tina, thanks. it worked.
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]

you're welcome

tina, thanks. it worked.
john