How do I link form controls to tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Text Box Control on a form and I want it to pull a specific record
from a table. To be exact: It is the Company name but I want it to select
it from record 1 in the Company name table. Any help appreciated.....
 
I have a Text Box Control on a form and I want it to pull a specific record
from a table. To be exact: It is the Company name but I want it to select
it from record 1 in the Company name table. Any help appreciated.....
Click to expand...

Not really sure about what it is you wish to do, as there is no such
thing as 'Record 1' in Access, only the first record of a particular
sort order.
Perhaps you can use DLookUp to get the value of a field in a record.
=DLookUp("[CompanyName]","CompanyNameTable")
You may need to add criteria to assure the correct record is returned.
Look it up in VBA Help.
 
Back
Top