RE: Open Form based on a record selected in a subform

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









"NKA" wrote:

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