FindRecord

[Guest]

Am attempting to open a Form (B)to be showing the same record as is showing
in the preceeding Form (A).

The record is defined by its autonumber key (ID)

Form B is opening to the first record instead.

I defined the 'Find What' field of the FindRecord macro step with:
[ID]=Forms!FormA.ID

Since it did not work I preceeded the FindRecord with GoToControl and
defined that for: ID hoping that would help....

so the macro steps (not including some preceeding query tasks) are:
OpenForm: B
GoToControl: ID
FindRecord: [ID]=Forms!FormA.ID

but no luck - opening still to first record...

 

[Guest]

Try it this way --
OpenForm: B
GoToControl: ID
FindRecord: =[Forms]![FormA]![ID]

 

[Guest]

bingo....

thanks much
--
NTC

Try it this way --
OpenForm: B
GoToControl: ID
FindRecord: =[Forms]![FormA]![ID]

--
KARL DEWEY
Build a little - Test a little

Am attempting to open a Form (B)to be showing the same record as is showing
in the preceeding Form (A).

The record is defined by its autonumber key (ID)

Form B is opening to the first record instead.

I defined the 'Find What' field of the FindRecord macro step with:
[ID]=Forms!FormA.ID

Since it did not work I preceeded the FindRecord with GoToControl and
defined that for: ID hoping that would help....

so the macro steps (not including some preceeding query tasks) are:
OpenForm: B
GoToControl: ID
FindRecord: [ID]=Forms!FormA.ID

but no luck - opening still to first record...