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

  • Thread starter charlie via AccessMonster.com
  • 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
 
A

Albert D. Kallal

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top