DB Add Record doesn't work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Desert bear said:
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?
Click to expand...

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.
Click to expand...

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.
 
Back
Top