areas of forms as button

  • Thread starter Thread starter simon
  • Start date Start date
S

simon

Hi...wondering if you could help

In access 2000, i have a continuos form showing some
records from a table (e.g. company name, phone number).
what i was wondering if there was a way, so that a user
just has to double click on each record (not a button -
the actual record) to open a new form with the rest of the
information about only that record. does that make sense?
 
You can use the doubleclick event of all the controls in your subform.
To ensure that you have the same code everywhere, you could move the logic
to a subroutine in the same module.

In every doubleclick event there is just one line
Call OpenNewForm

Private sub OpenNewForm
' some logic here
docmd.OpenForm,...
end sub

HS
 
Back
Top