From datasheet, drill down into detail?

  • Thread starter Thread starter CW
  • Start date Start date
C

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

Daryl S said:
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


CW said:
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
Click to expand...
Click to expand...
 
Back
Top