Form not allowing me to add new records

[dcnick]

I have a form based on a select query (query does calculations as well). The query pulls from 2 linked tables, and it's not allowing me to add new records. On the form properties, I have "allow additions, allow deletions, allow edits, and data entry" set to yes. I've tried adding code to go to a new record when the form opens and this doesn't work, either.

Any suggestions?
Thanks in advance.

 

[llkhoutx]

With two linked tables as your record source, you may have a "non-updatable recordset."

 

[dcnick]

Stink...ok, thanks.