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.

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


"iccsi" <(E-Mail Removed)> wrote in message
news:56fa3657-d24b-4cb0-8ff5-(E-Mail Removed)...
>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,

On Jun 13, 4:10*pm, "Access Developer" <accde...@gmail.com> wrote:
> 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
>
> "iccsi" <inu...@gmail.com> wrote in message
>
> news:56fa3657-d24b-4cb0-8ff5-(E-Mail Removed)...
>
>
>
>
>
>
>
> >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,

Thanks for helping,