Records Source for frmPersoonel

[Lou_Reed]

In the file db that I have attached this was saved on 4/4/2017. It this db was created before I started renaming tables this db mostly works.



My new db based on this db with tables renamed to remove spaces fails on fmrPersonnel.


My question is on:

fmrPersonnel

what is the record source? I have not seen such a definition of the record source before. The db works.

This part of db was not written by me. it was written by someone else. I need to understand the record source it is:

SELECT qryPersonnel.* FROM qryPersonnel;

unlike the other files.

This is not listed in the navigation pane as a query. So what is it?

Any help appreciated. Thanks in advance.

[Bulzie]

Check to see if that is actually a table, sometimes folks name tables are queries and vice versa.

[Lou_Reed]

I checked tables in Navigation pane; it is not there. I copied the query dialogue/name from the old db to the new db and it failed.

I cannot understand why it works in old db and fails in new. It just seems to be an odd definition.

As I said I copied:

SELECT qryPersonnel.* FROM qryPersonnel;


from the old to the new and nothing worked. If you look at the query qryPersonnel it is quite simple.

I just need some to explain what is going on here. This should work.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[andy49]

Lou I've just looked in the pane and I can see the qry in question.

[CJ_London]

this

SELECT qryPersonnel.* FROM qryPersonnel

is SQL i.e. a query which is selecting everything from an object called qryPersonnel - which in this case is a query and is in the db's included in your attachment.

form/report recordsources do not have to be a table or query, they can also be a sql statement such as this - often used to order or filter data specifically for this form rather than using a separate query

In this case a recordsource of

qryPersonnel

would work just as well