ms access - How to limit which fields can be updated in a form? -
i making form in ms access 2013 , has 5 fields, form used create "event." when creating event, 5 fields used. however, same form used update event. when updating event, 3 of fields should changed. how can create 2 of fields ignored when updating? not want create separate form updating.
one alternative set field.enabled = false if primary key of record (shoudl field of type autovalue) set value in form_current trogger, i.e. this:
private sub form_current() if isnull(me!pk) me!field.enabled = true else me!field.enabled = false end if end sub
(just replace pk , field real field names)
forms ms-access ms-access-2013
No comments:
Post a Comment