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

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

performance - Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures? -

jquery - Responsive Navbar with Sub Navbar -