Requery Help

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

I have two cbo boxes -
both use querys as record source
CBOone selects stations 3 character string
and CBOtwo uses a query for rthe record source that has a parameter
Forms!frmMain.cboOne

I want to dynamically change the selection list in CBOtwo based on the
station selected in CBOone.

How /where should i use requery after updating cboone so that cbotwo (i.e.
the query) will have the correct list.

it works if i leave the form and then return to the form - but i need it to
update as soon as cboone is updated.
thanks for any help
 
Junior said:
I have two cbo boxes -
both use querys as record source
CBOone selects stations 3 character string
and CBOtwo uses a query for rthe record source that has a parameter
Forms!frmMain.cboOne

I want to dynamically change the selection list in CBOtwo based on the
station selected in CBOone.

How /where should i use requery after updating cboone so that cbotwo
(i.e. the query) will have the correct list.

it works if i leave the form and then return to the form - but i need
it to update as soon as cboone is updated.
thanks for any help
Click to expand...

The combo box has an AfterUpdate event. Put it there:

Private Sub CBOone_AfterUpdate()

Me!CBOtwo.Requery

End Sub
 
Back
Top