Opening a new form from a form using command button

[rmr]

Hi this is my first time using this forum, I hope someone can help.
I have a form 1 and I want to open another form to display data specific to the record showing in form 1.

I have done this many times successfully but now I am getting an error msg "The sepcified field '[UnitID]' could refer to more than one table listed in the FROM clause of your SQL statement.

I have tried everything but cannot solve this one. Any suggestions?

 

[allan57]

Your query might be referring to 2 or more tables containing the field [UnitID], you need to uniquely identify in the query which table the field is coming from i.e. [TableName].[UnitID]

 

[rmr]

Thanks I will give it a go!

 

[rmr]

Thanks for that I will give it a go!

 

[rmr]

Wow it worked!. You don't know how long I have been trying to figure that one out! Thanks again