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
