This recordset is not updateable...

[Guest]

Background:
I have created two forms to view the information in an asset database: One
form (Asset) looks up by asset number (the asset number is also the key field
for the database), the other form (Location) looks up the assets that are
located at a particular office or location. I am trying to link the two
forms using a macro:

the Macro:
At the Location form, there's a button called "view asset", which uses a
macro to take me to the Asset form and show the details on that particular
asset. Here's the macro:

1) OpenForm - opens the Assets form
2) SetValue - sets the value of the lookup combo box in the Assets form to
the asset number wanted:
Item: [Forms]![Assets]![cmbAssetID]
Expression: [Forms]![Location]![Location of Assest subform].[Form]![AssetID]

3) Close - close the Location form
4) Requery

The problem:
When I get to the Asset form using the above macro, I can't edit any data.
I get this message: "This recordset is not updateable." I want to be able to
edit the data when I get there.

Can anyone help?

Thanks in advance

 

[Barry Gilbert]

If you open the Assets form directly, is the recordset updateable? Is
it only an issue when the macro opens it?

 

[Guest]

Yes, it is updateable when opened directly. It's when I go to it via the
macro that won't allow updates.

 

[Guest]

In the macro, check your selection in the Data Mode property. This should be
left blank. When it's blank, it picks up the settings saved with the form.

 

[Guest]

Barry,

Thanks for your advice. I checked the Data Mode property in the macro, and
it is blank. Any other ideas?

Darren