areas of forms as button

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?
 
H

HSalim

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
 
Top