details record on the form

[iccsi]

I have a form to to link to record source and would like to show a
plus sign "+" on the form and user can get details record of the
record just work like table.

Can you please show me how to do this operation?
Your help is great appreciated,

 

[Access Developer]

If you mean you have a Continuous Forms view, and want to display the detail
of the current Record by clicking a Control containing a "+" (plus sign),
then create a Command Button with a picture of a "+", and in the Click
event, use VBA code to retrieve the unique key of the currently-selected
Record, and use it to construct the WhereConditon argument of a
DoCmd.OpenForm that will open a Form that you have created which shows all
the detail in SingleForm view.

I often accomplish this by placing the code in the DoubleClick event rather
than creating a Control.

 

[iccsi]

If you mean you have a Continuous Forms view, and want to display the detail
of the current Record by clicking a Control containing a "+" (plus sign),
then create a Command Button with a picture of a "+", and in the Click
event, use VBA code to retrieve the unique key of the currently-selected
Record, and use it to construct the WhereConditon argument of a
DoCmd.OpenForm that will open a Form that you have created which shows all
the detail in SingleForm view.

I often accomplish this by placing the code in the DoubleClick event rather
than creating a Control.

--
 Larry Linson, Microsoft Office Access MVP
 Co-author: "Microsoft Access Small Business Solutions", published by Wiley
 Access newsgroup support is alive and well in USENET
comp.databases.ms-access

Thanks for helping,