Good Afternoon,
New question has been brought about, Can you tell me what is wrong with my SQL Where Expression below. The form itself is unbound, The table lists there name and SSN which the SSN is the primary key of each person.
I have currently,
=[Forms]![Master Index Sheet]![Combo23]=[Tables]![Personnel Information]![SSN]
Tells me the automation object tables doesnt exist.
I have tried other variations as well to include SSN = SSN and everything. The only way I get it to work is if the form on open is bound to the table but then my other selects for other tables on same form will not work that I will need on this.
Please let me know what you think,