Click On Record Return Same Record On Another Form

[a_20120]

Hello EveryOne!!!
I have two forms which is bounded to one table.

1. FormOne is Continous (Tabular)
2. FormTwo is Single (Columnar)

when I click on any record of the FormOne, I want to Same Record on FormTwo. How can I do This?

 

[norman]

I used this method to open another form showing more information on a record.

On the tabular form choose the field which you want the user to 'click' on.

Go into design mode select the field you have chosen. Select properties,
then select the on click property. Use the code below, substituting your own field and form names.


Dim mywhere, mytab

mytab = "frm2" '...the form you want to open
mywhere = "fldpersonid = " & Me!fldPersonID '...the unique key


DoCmd.OpenForm mytab, , , mywhere, , , 2

HTH

Norman

 

[Bat17]

Make form 2 a subform of form 1
peter