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