From datasheet, drill down into detail?

[CW]

On our customer company form I have a subform datasheet displaying the
several contact persons at that company. Due to limited space, only a few
details are visible for each person.
Can I have a drilldown / expand facility whereby we could select a person
and a suitably sized single form would pop up for that record, allowing the
full details to be added/edited/viewed? If so, how please?
Many thanks
CW

 

[Daryl S]

CW -

You could have the user select a record and click on a button or maybe just
double-click on the record and then open the new form that is editable. In
the subform's Double-Click event, use code like this (use your form, field,
and control names):

DoCmd.OpenForm "NewFormName", acNormal, , "[KeyFieldName] = " &
Me.KeyFieldControlName, acFormEdit, acDialog

 

[CW]

Thanks Daryl - that is working nicely. One of your many helpful responses
today - I noticed that you've replied on just about every post!!
Many thanks
CW

CW -

You could have the user select a record and click on a button or maybe just
double-click on the record and then open the new form that is editable. In
the subform's Double-Click event, use code like this (use your form, field,
and control names):

DoCmd.OpenForm "NewFormName", acNormal, , "[KeyFieldName] = " &
Me.KeyFieldControlName, acFormEdit, acDialog

--
Daryl S

On our customer company form I have a subform datasheet displaying the
several contact persons at that company. Due to limited space, only a few
details are visible for each person.
Can I have a drilldown / expand facility whereby we could select a person
and a suitably sized single form would pop up for that record, allowing the
full details to be added/edited/viewed? If so, how please?
Many thanks
CW