Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting a record value from a Second Table

Status
Not open for further replies.
JimCowan

JimCowan

Technical User
Jul 12, 2000
10
CA
I need code to access a particular field record in a different Table. ACCESS wants to look only at the current Table, being the one underlying my ComboBox on a form.
How do I point access to the new table, and what code is correct to place the field record into a variable?
 
Sort by date Sort by votes
Investigate the dlookup() function

strvariable = dLookup("[fieldname]","Tablename","criteria")

or use DAO,ADO or SQL to get the value as well

Good Luck
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
671
OCM
OCM
renigar
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
369
renigar
renigar
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
536
Moss100
Moss100
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
573
lmcate
lmcate
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
652
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top