vba - Access navigation control: load same form in Add mode or Edit mode -
i trying play bit navigation form in access 2010.
simplify, have 2 buttons, 1 load subform in data entry mode, other 1 load same subform in edit mode (but filter).
the first idea had check open event of subform button clicked in navigation form , set sub form properties (dataentry
, allowedits
) accordingly.
- is right way achieve goal ?
- how can find navigationbutton active in navigation form, subform ?
i played properties, examined objects in debug mode couldn't find answer.
found answer....in navigation form, removed form name navigation button , added code:
private sub navigationbutton7_click() docmd.browseto acbrowsetoform, "trades", "menu.navigationsubform" navigationsubform.form .allowadditions = true .dataentry = true end end sub
Comments
Post a Comment