G
Guest
I'm trying to write a macro that will allow me to find a specific record in
"Form A" by matching two fields in that record to two fields in "Form B".
(This by using the [forms]![formname]![fieldname] expression as the
argument.) "Field A" is an interger, and "Field B" is a string. The macro
functions off a button-click, so pulls the information from the current
record, if I'm correct in my thinking.
I've got it to work nicely enough finding just the interger, but run into
problems with either finding the one record where both match, or for that
matter, just the string (when the string consists of letters and
numbers--when the string is just a number, it works fine too).
I've tried OpenForm, and GoToRecord, etc. and am finally admitting to myself
I'm stumped. I may just be fixated in my thinking and missing something
simple, too. Any suggestions? Thanks in advance!
"Form A" by matching two fields in that record to two fields in "Form B".
(This by using the [forms]![formname]![fieldname] expression as the
argument.) "Field A" is an interger, and "Field B" is a string. The macro
functions off a button-click, so pulls the information from the current
record, if I'm correct in my thinking.
I've got it to work nicely enough finding just the interger, but run into
problems with either finding the one record where both match, or for that
matter, just the string (when the string consists of letters and
numbers--when the string is just a number, it works fine too).
I've tried OpenForm, and GoToRecord, etc. and am finally admitting to myself
I'm stumped. I may just be fixated in my thinking and missing something
simple, too. Any suggestions? Thanks in advance!