Adding a new record when the record source is a query.

[Andy]

Hello All,

I have a form that runs a query. The reason it runs on a
query is because prior to it opening I have a form from
which you can pick and choose what you want to see.

For example if I want to see Open, Green, and Record whose
due date is today's date.

The reason that I run it on a query is because the options
that a user has the ability to choose from are from
multiple tables. Everything was working well, until I
decided to add a new record and Access fought back. The
Record_ID (Primary key) didn't come up. It's an
autonumber. I believe this is happening because the
record source is a query.

Is there a way to fix this, or a way around it?

Any help or feedback would be great.

Thanks.