L
Lesah
I posted earlier about transferring data from one field to another in an old
database. Also need to update what is apparently an ancient filter. It has
a command button which brings up a grid with "LastName, FirstName, Soc Sec".
I key in any of those fields and it brings up matching records in form view.
The command button runs a macro: Action is Run Command. Then uses Send
keys, {up}{up}+{tab}+{tab}+{tab}l{tab}f{tab}s+{tab}+{tab}{down}{down}. This
positions the curser in the Soc Sec field. It somehow replaced Soc Sec field
with the (show all fields Apps*) which I know can not be a search field. I
cannot get it back the way it was. I know that SendKeys are almost obsolete,
but I don't know any other way to do it. Here is what shows up in the
command button properties: On Click - mcrFindApplicant
Can anyone suggest a way to fix this, or a better way to search for a form?
database. Also need to update what is apparently an ancient filter. It has
a command button which brings up a grid with "LastName, FirstName, Soc Sec".
I key in any of those fields and it brings up matching records in form view.
The command button runs a macro: Action is Run Command. Then uses Send
keys, {up}{up}+{tab}+{tab}+{tab}l{tab}f{tab}s+{tab}+{tab}{down}{down}. This
positions the curser in the Soc Sec field. It somehow replaced Soc Sec field
with the (show all fields Apps*) which I know can not be a search field. I
cannot get it back the way it was. I know that SendKeys are almost obsolete,
but I don't know any other way to do it. Here is what shows up in the
command button properties: On Click - mcrFindApplicant
Can anyone suggest a way to fix this, or a better way to search for a form?