I have two tables:
1. Dealer (Dealer Code, Dealer Name, Contact, etc)
2. Transactions (Customer, Dates, Amount, Dealer Code, Dealer Name, etc)
When entering the transaction information in the form... I would like to enter the Dealer Code and have the Dealer Name populate.
I have been attempting this for a few days and am now getting negative results.
Can someone point me in the right direction?
In excel this is an easy VLookup...
Hi njexpress9
Roy has a good download to show you how
J & R Database Form...
http://www.excel-it.com/vba_examples.htm
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
VBA for smarties - snb
Is the dealer code being populated through a combo box look up? If so, then use the this formula in the text box for the name.
where x represents the column number for the field in your lookup for the dealer name and comboboxdealerid needs to be changed to the name of your combobox. The first column in the Query grid is 0 and numbers 1-up from the left.= comboboxdealerid.column(x)
Alan
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks