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!

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

How to make a field update to a dif. lookup selection field

Status
Not open for further replies.

number2

Technical User
Oct 25, 2001
284
US
I am trying to do the following:
1)After selecting a contact name from a combo box
2) Have the following address field update to the contacts address information.
I have tried with no success, I can not "bind" the record to the contact tables record correctly I think.
Thanks!
 
Try: me!adress = me!combo.column(2) - where 2 holds addres info.
If your combo does not hold this info you could try a dlookup("Adress","Adresses","AdrID=" & me!combo.column(0).

Place your code on after update
 
Thanks. It sounds like you know what I am trying to do. It should be simple, but of course...

can you be a bit more precise on exactly what steps I would need to go through? I tried placing that code but it didnt work.
Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top