Lookup on a Form

  • Thread starter Thread starter Joe Cilinceon
  • Start date Start date
J

Joe Cilinceon

I have a tenant form (with several subforms) that now I access a tenant by
using a combo box to type the tenants name or look it up. This form is
linked to a tenant info table only. I would like to something like an input
on the form to enter a Unit number instead of the name. The unit table isn't
directly linked in this case. I was wondering if there is a method of
finding the custno using a unit number in the Unit table to seed the form. I
hope that is clear.
 
Back
Top