Form's Recordsource question

[it2hill]

All,

I am helping a co-worker with an Access project. We have a form that has pages on it and we would like to edit the data there, so I started making sure the table has a PK and those type things. In looking at the forms recordset, it shows:

SELECT [tblIncidents-Join].*
FROM [tblIncidents-Join]

I do not have a tbl or qry called -Join. Where is this recordset getting built from?

This is exsisting code that the origianl developer has since gone.

Thanks!

 

[HarleyQuinn]

Might sound a daft question but do you have a table called tblIncidents-Join ?

Cheers

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[it2hill]

Nope, not a table or qry called that. I do have the table called tblIncidents.

If I run the select stmt as a qry, it promts me for a value from the form. Something like form.bla.controll.

Thanks again.