Running a query based on 2 combo boxes.

[blessoni]

Hi,
I am new to access and am trying to do a project.I am stuck,wish some one could help me out.I have made 2 combo boxes which are unbound and seems to work fine in a form.I want to make a query based on the selectionof both the combo boxes.Say,one combo box has locations and other items(chairs,tables,etc,etc).When i select a location in a combo box and table(item) in the other combo box,I want to see all the table names in that location.I tried putting in criteria Forms!FormName!ComboboxName for each but it returns a blank.Can somebody help me please..Thanks in advance.


P.S I donot know VB.

[orange]

Take a look at the video tutorials here
http://www.datapigtechnologies.com/f...combobox1.html
http://www.datapigtechnologies.com/f...combobox2.html
http://www.datapigtechnologies.com/f...combobox3.html

[blessoni]

Thanks Orange for the reply,but I want a report to be generated based on the criterias in 2 combo boxes,Can you help with that one please.

[orange]

Thanks Orange for the reply,but I want a report to be generated based on the criterias in 2 combo boxes,Can you help with that one please.

Take a look at the tutorial on Dynamic Reports at

http://www.fontstuff.com/access/acctut19.htm

[blessoni]

Thanks alot Orange..It works very well..