Prev: Invoice Numbers
Next: Skipping a line by condition
From: Sheila on 10 Feb 2010 08:05
I have a form containing some text fields (orders) as well as a combo box
(customer id and name).

The record source of the form is a query joining the two tables order and
customer.
The control source of the combo box is the customer id from the above
mentioned query.
The row source of the combo box is the customer table, containing the two
columns id and name.

The first column of the combo box, the id, is bound.

The report contains the same fields as the form. The two columns of the
customer form combo box are represented in the report as two text boxes.

The record source of the report is the same query as the one of the form.
The control source of the two customer text boxes is the customer id and the
customer name from the above mentioned query.

If the width of both columns in the customer combo box is greater than 0, I
can set a form filter on that control and then generate the report with the
same filter. No problem there.

But if the width of the bound column is zero (as the users are interested in
the customer names, not their id), I am asked to “enter parameter value” for
the customer name before the report is generated. The report is then
generated with no records at all.

How can I generate a report based on a form filter with multi-column combo
boxes when the width of the bound column is 0?


If this does not work at all, does somebody have an idea for a workaround?

Any help is appreciated!
 | 
Pages: 1
Prev: Invoice Numbers
Next: Skipping a line by condition