Error Message Regarding Record Source

Question

In Access, I created a table and attempted to create a report based on it.

I am getting the error message below:

 "The record source '~sq_dAccess Applications~as_Type' specified on this form or report does not exist.

The name of the recordsource may be misspelled, or the recordsource  exist in a different database in the Form or Report's Design view or Layout view, display the property sheet by clicking the Properties button, and then set the RecordSource ..."

There is only one table in this Access file.  I followed the instructions to re-select it to no avail.  

I also re-created the report from scratch with the same results.

Also, the reports do not show the contents of fields with value lists distincly?  Is there a setting that I need to do that?

Answer 1

It seems you might be using lookup fields defined in your table designs. Generally this is a bad idea. It is also not recommended to use value lists for your lookup fields and/or combo boxes.

Consider using only small lookup tables and combo boxes on forms. Then your reports can join your main table to the lookup tables to produce the desired results.

Answer 2

I reinserted the fields in the report and it resolved the problem of the table name appearing instead of the field contents in the report.  I am good to go.  Thanks for your help.

Answer 3

Thanks very much!

That solved the problem of the error message.  But, now, the report shows the names of the tables rather that the data in the table.

For example, instead of showing the selection for each category in the report's detail, it shows the ame of the table "Category"

I created table for Category, Type and Software.  Then I set each of the ose fields to link to its respective table as follows: Display Control: Combo Box, Row Source Type: Table/Query, Row Source: (the corresponding table).

Can you help with that?