This Recordset is not updatable

  • Thread starter Thread starter HELP
  • Start date Start date
H

HELP

I am linking two forms through a command button. The
queries that the information comes from runs fine. The
error comes when I click the command button on the form to
go to the linked form. They are joined by two fields.
Could that be the problem? I am not trying to update
anything, just trying to filter. It should give me all
items for a certain vendor based on a certain customer.

Any help will be appreciated.....
 
It is completely impossible to provide any help based on what you tell
us here.
Please post your table structure, how forms are using the data and what
you *want* to happen, not just how it is not happening.

Good luck,
Pavel
 
-----Original Message-----
I am linking two forms through a command button. The
queries that the information comes from runs fine. The
error comes when I click the command button on the form to
go to the linked form. They are joined by two fields.
Could that be the problem? I am not trying to update
anything, just trying to filter. It should give me all
items for a certain vendor based on a certain customer.

Any help will be appreciated.....
Click to expand...

Look at the relationship between the two tables. If acces
lists it as undetermined, then you won't be able to edit
the recordset. The relationship type has to be 1-to-1 or 1-
to-many. You need to have unique index (primary key) on
one of the joining fields.
 
Back
Top