Form isn't going to NEW Record (1 Viewer)

[sladetroityer]

Access 2010, Navigation Form.
I have an Employee Add form as a subform on a Navigation tab. The form is based of the Employee query. The Data Entry property is set to YES but the form is bringing up the first record in the query instead of the NEW blank record that would allow the addition of a record. When I take the form and paste it into a new or different database it works as it's supposed to.

Please help.

 

[vbaInet]

If you say that it works when you move it to another database, then import it from the working db.

 

[sladetroityer]

I did try that with no luck. It appears that I have to create a new query for the employee Add tab. The employee information has too many other tables linked which causes the Data Entry option to not work.

 

[missinglinq]

As you've found out, Multi-table Queries are frequently Read-Only and thus cannot have New Records added! For the reason for this phenomenon have a look at Allen Browne's short article on the subject:

http://allenbrowne.com/ser-61.html

Linq ;0)>