details record on the form

  • Thread starter Thread starter iccsi
  • Start date Start date
I

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,
 
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.
 
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
Click to expand...

Thanks for helping,
 
Back
Top