Sunday, 15 February 2015

ms access - How to limit which fields can be updated in a form? -



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