synergy46

Keeping Record focus after Find

Discussion created by synergy46 on Jan 9, 2014
Latest reply on Jan 12, 2014 by mardikennedy

I am using FM 13 Adv

I have a table: Members

PKMemberID

LName

ActiveInactive (Holds 'Active' or 'Inactive' status)

MemCan (Holds 'Member' or 'Candidate')

 

etc.

 

The table holds Members and Candidates, Active and Inactive designations for each.

 

With the record pointer on Fred Flintstone, I search for "Active" and "Member" to find

that group. Great.

But, once I find the group, I need to put the record pointer back on the Fred Flintstone record.

 

I have tried collecting Fred's PK in a variable. OK. And then I Find it. OK. Now have Fred's record

in a set of 1 of 1. When I now search for all Members who are Active, I loose the focus of Fred's record.

Now, Dave Crocket's record has the focus.

 

Here is my script:

($$MemPKID is prevously established as the KP_MemberID)

btnactivinactive.png

Thanks for your thoughts....

 

Ron

Attachments

Outcomes