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

[Guest]

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.

 

[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

 

[Van T. Dinh]

See the Access Web article:

http://www.mvps.org/access/forms/frm0028.htm