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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Form field equal to another table field

Status
Not open for further replies.
Tracyice

Tracyice

Technical User
Mar 10, 2004
30
US
I'm sure this has a simple answer. I want to set one value in my form equal to another value in a table. I want to use VBA for this, because the data will not always come from the same table, and I want the user to be able to specify the table it should come from.
 
Sort by date Sort by votes
Take a look at the DLookUp function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
679
Moss100
Moss100
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
809
dhookom
dhookom
Zyborg
  • Locked
  • Question
Using a variable as reference to a form
Replies
5
Views
771
Zyborg
Zyborg
V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
652
strongm
strongm
OzFoxy
  • Locked
  • Question
How to get AttachmentCount from a field in a table
Replies
2
Views
352
OzFoxy
OzFoxy

Part and Inventory Search

Sponsor

Back
Top