Open Form based on a record selected in a subform

[NKA]

Hi all,

I am a little rusty with Access to say the least and am struggling further
with trying to navigate Access 2007!!

I have the following:

Mainform = Tasks
Subform = Servers (filtered by ServerID)

I would like to double click the record and open a new form called Notes
(filtered by ServerID). This form also needs to open if there are no notes
currently entered for that particular server (ie new record available for
edit).

I seem to recall you can double click a record (datasheet view) in a subform
to open another form but for the life of me cannot remember how or what the
coding is!.

Any help greatly appreciated.
NKA

 

[NKA]

I have now managed to work out how to open my form (frmServer) based on the
value of a field in my nested subform. I am passing this value through to
the new form into an unbound control (txtServerID) which is working fine.

I now need to filter the records to only display the record that matches the
value of the unbound control. The form displays server details and some
input fields with a subform for entering notes which are datestamped (linked
by ServerID).

I have tried to apply a filter which does filter the records (showing 1 of
1), however, no data is displayed.

I need to be able to filter this form to show the server details as selected
initially. This in turn will display all the notes for that server.

Assistance from anyone who knows would be greatly appreciated.
NKA