So i am building a business database in Access 2007 for an assignment and I stuck on this one area. I am suppose to produce a user interface that allows a user input and displays the results of all businesses in a particular city/town as chosen by a user from a list of all city/towns in the database. Is there any other way to do this without using a combo box?.. Cause i am having real problems getting the combo box to work as it should. tried that trial and error thing...still doesn't work. Any help would be nice. Thanks
Ok... probably I should also illustrate the problem i'm having with the combo box. Now the combo box is suppose allow a use to choose a particular city in the Business table and display the results. I created the combo box in the from as i was thought and i use the =[from]![Business Form]![city/town] in the query design to link the combo box to the particular from and then set the parameters, I think I am missing a step somewhere in between.