FindRecord

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

thanks much
--
NTC


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

--
KARL DEWEY
Build a little - Test a little


NetworkTrade said:
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...
Click to expand...
Click to expand...
 
Back
Top