query usage in a form

[sherik]

Hi. Please help. I have created a form for a bus company. I have added 'from' combo box, where list of cities from which the bus goes, and then created 'to' combo box, which list the cities where the bus goes. I want 'to' combo box list only those 'to' routes which are defined in my table. I have used the following article but it didn't work http://office.microsoft.com/en-gb/ac...001173058.aspx . That is for instance I have bus routes from NY to Boston, but not to Miami. So, when I choose NY as 'from' destination, 'to' combo box will list only Boston and not Miami. Thanks in advance

[June7]

Why didn't it work - error message, wrong results, nothing happens? Post attempted code for analysis. Show example of records used as the source for the comboboxes. Post the combobox properties RowSource, ColumnCount, ColumnWidths, BoundColumn.

See if this tutorial helps http://datapigtechnologies.com/flash...combobox2.html

[Missinglinq]

Does any VBA code run? To allow Code to run in 2007/2010/2013 you need to declare the Folder as 'Trusted.'

To trust your folder, click:

1. Office Button (top left)
2. Access Options (bottom of dialog)
3. Trust Center (left)
4. Trust Center Settings (button) on far right
5. Trusted Locations (left)
6. Add new location (button)
7. Enter Folder Name
8. Click on Okay

Linq ;0)>