Re: Take This Value and Shove It

Tech-Archive recommends: Fix windows errors by optimizing your registry

Since the borrower name is completely derivable from accountNo, you
shouldn't be storing it the second table (assuming that accountNo is stored
there)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Gwen H" <GwenH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6882827E-A008-4800-8026-6DD6D90C2A97@xxxxxxxxxxxxxxxx
I have a form named "enterLoanDocs". Its record source is the table named
"loanOpsTracking". On this form, I have a field named "accountNo" whose
control source is the field "accountNo" in the aforementioned table. I
also
have a field named "borrower" whose control source is:

=DLookUp("[name]","openLoans"," [loanNumber] = " &
Forms!enterLoanDocs!accountNo)

When I enter a value in the accountNo field, the form looks up the
borrower's name in the table "openLoans." However, when I finish filling
out
the form, the values in all the fields except "borrower" are entered in
the
loanOpsTracking table.

How do I tell the form to take the value in the borrower field and shove
it
into the borrower field of the loanOpsTracking table?

Thanks,
GwenH


.