G
Guest
I have a form that will be used to add records to a table "loanTracking". I
want the first field on this form to be a text field called "account". Users
will enter a loan number in account, and when they tab away from that field I
want it to look up the borrower's name in the query "openLoans". Then I want
to store both the user-entered loan number and the borrower's name in the
table "loanTracking." I do not want to use a combo box or list box for
"account".
What is the best way to do this? And can you please post pseudocode so I can
get an idea for the correct syntax?
Thanks!
GwenH
want the first field on this form to be a text field called "account". Users
will enter a loan number in account, and when they tab away from that field I
want it to look up the borrower's name in the query "openLoans". Then I want
to store both the user-entered loan number and the borrower's name in the
table "loanTracking." I do not want to use a combo box or list box for
"account".
What is the best way to do this? And can you please post pseudocode so I can
get an idea for the correct syntax?
Thanks!
GwenH