Error with select statement

[Coleman984]

I have a database that I have copied over from an existing database because the setup will be very similar. I have been able to locate the majority of the reference issues in regards to the select statements (i've changed query, table, and field names to be more logical). Now I'm not able to find these last couple of errors on a form.

Is there a bit of code that will output the name of the table that the select statement is trying to preform but not able to?

If that doesn't make sense lets try this. Is there a way to get access to tell me the name of the query / table / or whatever is causing the select error in a message box or whatever?

 

[MarkK]

I don't really understand the problem. You seem to be describing mostly how you imagine the solution will look.
When you open a form do you seem to be prompted for a value in a query? Do you supply the value, even a garbage value, and find that the form opens normally and seems to function OK?

 

[Coleman984]

I'm having trouble finding which forum or query is throwing the error. A few queries have similar select statements and I can't find the query / form that is throwing the error.

 

[PNGBill]

Are the forms queries embedded in the form or are they seperate queries ?

If they are embedded you can still open them as a query and resolve that issue first ie, get your query to work properly.

Embedded sql can be copied and pasted as a new query and then work on them to get them fixed.

This way you can "drill" down to queries that your form query may be referencing that has the problem.

What happens when you start changing field names is the query that has the old name will assume the name is like [Enter our Name] eg.
That is why is asking for user input.

If you are able to display this query in design view you may see the table listed and be able to work out what field was supposed to be entered.

Good idea when making changes like you have been is to have a spare copy you can open to see the query before you started your "improvements"