Combobox search

  • Thread starter smcgrath via AccessMonster.com
  • Start date
S

smcgrath via AccessMonster.com

I have 3 tables as follows

TblAtty
AttyID - Autonumber primary
AttyLast
AttyFirst
AttyOffice

TblPayoff
AcctNbr - text primary
Borrower
payoffdate
LoanType
RequestingAttyOfficeID
AttyAddress

TblDischarge
dischargeID - autonumber primary
AcctNbr
County
Book
AttyID
AttyAddress

I would like to create a form for the payoffs and a subform for discharges
that each have a search function (preferably a combobox) that searches the
corresponding attorney and poluates the address fields for each. Payoff has
one attorney and discharge has another attorney. Is it possible?
 
Top