record source does not exist message

[Guest]

When I open a form that has subforms, I get the following error message:
"the record source '~sq_cteams subform~sq_ccrewtype' specified on this form
or report does not exist.

I can open each of the component subforms without any problem. I don't have
any queries with names like that, and I don't know where the system is
getting that name from. Can anyone enlighten me?

 

[Guest]

I solved my own problem - there was a field called crewtype that had a list
box. The row source type should have been value list, but I had it as
table/query, so I guess Access was trying to create a query for the field.