how can I make a list in a form update? 9622

S

Sean

Hello. I have one combo list where the user chooses a street. This combo
boxe's name is street. The next combo box is based on a query which takes the
first combo boxes info and produces a list of stations on that road. That
combo boxes name is stations. I have read and tried to use the requery
command, and am just having no luck. Can someone help me? The combo box
stations won't update unless I close and repopen the form.
 
J

Jeff Boyce

Sean

Where (behind which control) are you trying the "Requery" command? What are
you trying to Requery?

Are you doing something like:

Me.cboStation.Requery

in the AfterUpdate event of the cboStreet?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top