[MS_AccessPros] Populate text box base on a combo lookup

 

I am not sure if I am working the title correctly. What I need to do is , I have a combo box called cmbUnit which has the following query:

Select unitid, unitcode from tblUnit.

Now I have a unbound textbox called txtTenant, which I need to be populated based on the value select from the cmbUnit. But the gotcha is that that value will need to be looked up in another table. I am trying to work out the code for After_Update event of the cmbUnit control. I am thinking it will be something like:

Select Locncode, Name from BA4602200 where locncode = cmbUnit.olumn(1).Value 

Or something like that.

Thank you,

Art Lorenzini

Sioux Falls, SD

__._,_.___

---

Posted by: dbalorenzini@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___