areas of forms as button

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

 

[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

 

[simon]

dont worry, i worked it out!! Cheers anyway

Simon