Edit fields on Continuous Form (1 Viewer)

[jco23]

I have a query with an outerjoin; two tables (no subqueries). When viewing the query in datasheet mode, I am able to edit the fields. However, when viewing the query within the continuous form, I am unable to edit the same field. I am able to successfully add new records (and when adding new records, I can edit those fields).

The field is tied to a combo box, and the data property is set to unlocked and enabled. Thus, I can see the choices from the dropdown menu, but obviously, I cannot make any changes.

Below are the methods I have attempted to change with no avail:
- change the properties for both the query and form to dynaset and dynaset with inconsistent updates
- set the properties of the form to datemode:=aceditform when opening the form
- force the data mode to unlock when the field has focus
- change the field from a combobox to a text box

So why would I be able to edit the field when in query mode, but not on a continuous form?

thanks!

 

[jco23]

disregard - I was able to find a work around by setting the form to allow edits on the load and/or the form_current event (me.allowedits = true). this also allows me to determine who make edits and who cannot.