click row on subform, then click button to open form to rcd in subform

  • Thread starter Thread starter charlie via AccessMonster.com
  • Start date Start date
C

charlie via AccessMonster.com

II have a main form with a subform(datasheet) view. I need to single click
on a row on the subform (in order to highlight the record) and then click on
a button to open a new form to the record that was clicked on the subform.
This is required by the User.


Any help with coding this is greatly appreciated.

Charlie
 
If you look at the following screen shots, I used a continues form..and
placed a button on the actual
"row" of the form.

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

The above means that you don't have to select the record first..but just
click on the button...

my users love this...

The code behind the button is

me.Refresh ' only need this if editing allowed
' on the continues form.

docmd.OpenForm "frmDetails",,,"id = " & me!id
 
Back
Top