Drilling Down on a Sub Form access 97

Hi,

Ive created a query which sorts out the records i need.
The query returns an abreviated view of the complete
record.
The results of that query are displayed in a subform in
datasheet view.

What i want to be able to do is click on one of the
abreviated records in the subform and open up another form
with the completed record on show.

ive created the form which displays the full record but
dont know how do sort out the bit that allows me to click
on a record in the subform datasheet and automatically
open up the form and display the correct record.

P.S im a bit of a code novice

The domd.OpenForm has an optional argument that takes a where clause.
DoCmd.OpenForm SomeOtherForm, acNormal, , "someID = " & Me.id, acFormEdit,
acWindowNormal


watch the wrap with above.

Notice the fourth arg. Basically you set up a where clause and concat the ID
from the partial rec form.
The actual word 'Where' is not used.
The other following args are also optional and are show for demo only

peter walker
wrote in message
...
Hi,

Ive created a query which sorts out the records i need.
The query returns an abreviated view of the complete
record.
The results of that query are displayed in a subform in
datasheet view.

What i want to be able to do is click on one of the
abreviated records in the subform and open up another form
with the completed record on show.

ive created the form which displays the full record but
dont know how do sort out the bit that allows me to click
on a record in the subform datasheet and automatically
open up the form and display the correct record.

P.S im a bit of a code novice