Combo - Query help

vicsalt

Registered User.
Local time
Today, 22:51
Joined
Aug 22, 2008
Messages
48
Please help.
Ive created a form and added a unbound combo box using the wizard. the combo box looks up values from a field in a existing table. (I told the wizard to remember the value for later use).
Ive added a button to then run the report generated from the query.

the query uses the following criteria: Forms![employees frm]![namecmbo].
(criteria/build/select form and then select the combo box)

When the query runs it finds no records. Everything seems fine and have done this numerious times with other databases ive created.

Thanks
 
Simple Software Solutions

Make sure the bound column on your combo box is a match for the field in your query.
 
Sorry in the properties of the combo box under bound colloumn i have the value 1

What do you mean.

The criteria in my query points the the value of the combo in the form

Thanks
 
If you have a combo box that contains one or more columns you have to stipulate which column contains the criteria or reference you want to quantify.

In your case, lets say you have a list of people's names and their code. The code may be in either column 1 or 2 depending on how you have built or addressed the query or table.

You nominate column 1 as being the bound column

If you have code in column 1 with a width of 0 (zero) and the name in column 2 when you open the combo box you will only see the names. However when you run the report it will use the code column (bound column) as one half of the criterion.

In your report you will need the code in the detail section and then apply the filter beween the code in your rreport and the code in your combo box.

Hope this is morre clear for you

CodeMaster::cool:
 

Users who are viewing this thread

Back
Top Bottom