DB Add Record doesn't work

[Desert bear]

I have a form based on a query.
I used the command wizard for an "Add Record" command button.
When I push the button, I get "You can't go to the specified record"
How do I fix this?

Also, what is a "type 1 join"? I'm familiar with inner and outer joins, but not type 1.

 

[Dirk Goldgar]

I have a form based on a query.
I used the command wizard for an "Add Record" command button.
When I push the button, I get "You can't go to the specified record"
How do I fix this?

Make sure your query is updatable. If you open the query directly from
the database window as a datasheet, is there a "new record" available?
If not, the query is not updatable. See the help topic "When can I
update data from a query?" for possible reasons and solutions.

Also, what is a "type 1 join"? I'm familiar with inner and outer
joins, but not type 1.

I'd guess that if someone referred to a "type 1" join, they meant an
inner join -- if you are in query design view and choose to edit a join
line between two tables, you are given three choices; the first is an
inner join, the second and third are left and right outer joins.

 

[Desert Bear]

Thanks. It worked.