• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

Is there a way to make a form bound to a query updatable?

I have a form bound to a query which has two tales linked.  When I try to update a field in the form I can't because I guess the record is not updatable.  The form is opening in datasheet view if that matters.
0
SteveL13
Asked:
SteveL13
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try changing the form's property Recordset Type to Dynaset (Inconsistent Updates)

see this link too..

When can I update data from a query?
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now