G
Guest
My combo box fields that I choose on a form do not print on the report.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
Suzanne
Way too little information to guess!
Are you printing the form, or have you created a report?
Are the form's comboboxes bound or unbound?
Does the report's source include the fields that you refer to in the form
(if bound)?
Have you referenced the form's combobox fields (if unbound)?
What is the SQL of the source you use to generate the report?
How are you trying to show the underlying values in the report?
....
Way too little information to guess!
Are you printing the form, or have you created a report?
Are the form's comboboxes bound or unbound?
Does the report's source include the fields that you refer to in the form
(if bound)?
Have you referenced the form's combobox fields (if unbound)?
What is the SQL of the source you use to generate the report?
How are you trying to show the underlying values in the report?
....
G
Guest
Hi, Suzanne.
If they don't print at all, I suspect that they are not in the RecordSource
(the report's underlying table or query). If they are printing numbers, the
likely souce is that the combo boxes on your form are probably storing a
numeric code for the selection (determined by which column is the Bound
column), yet display meaningful text.
The solution to both is to include the fields you need in a multi-table
query, and base the report on it. You will need to make sure that you link
related tables by their foreign keys. For example, to print an Invoice for a
customer, you would need the Orders table, the OrderDetails table, the
Products table, and the Customer table, at a minimum. The Orders and
Customer tables would be linked by the CustomerNumber, the OrderDetails table
and Products table by the ProductID, and the Orders and OrderDetails table by
the OrderNumber.
If you've never worked with a multi-table query before, simply pick all the
tables you need, and drag each linking field to its corresponding field in
the related table to establish the link. If you have previously defined
Relationships (Tools, Relationships from the database window), or if the
fields have the same name, Access will provide these links automatically.
Then simply choose all the fields your report will need: CustomerName,
Phone, etc. from the customer table, OrderNumber, OrderDate, etc. from the
Orders table, ProductName from the Products table, and so on.
Return to your report and set the RecordSource property to your query, and
all of these fields will be available.
Hope that helps.
Sprinks
If they don't print at all, I suspect that they are not in the RecordSource
(the report's underlying table or query). If they are printing numbers, the
likely souce is that the combo boxes on your form are probably storing a
numeric code for the selection (determined by which column is the Bound
column), yet display meaningful text.
The solution to both is to include the fields you need in a multi-table
query, and base the report on it. You will need to make sure that you link
related tables by their foreign keys. For example, to print an Invoice for a
customer, you would need the Orders table, the OrderDetails table, the
Products table, and the Customer table, at a minimum. The Orders and
Customer tables would be linked by the CustomerNumber, the OrderDetails table
and Products table by the ProductID, and the Orders and OrderDetails table by
the OrderNumber.
If you've never worked with a multi-table query before, simply pick all the
tables you need, and drag each linking field to its corresponding field in
the related table to establish the link. If you have previously defined
Relationships (Tools, Relationships from the database window), or if the
fields have the same name, Access will provide these links automatically.
Then simply choose all the fields your report will need: CustomerName,
Phone, etc. from the customer table, OrderNumber, OrderDate, etc. from the
Orders table, ProductName from the Products table, and so on.
Return to your report and set the RecordSource property to your query, and
all of these fields will be available.
Hope that helps.
Sprinks