[MS_AccessPros] Updating row in drop down control

 

Hello, I'm trying to get the hidden columns in a drop down to update when I programatically update the dropdown with a value.  

I have a Unit drop down tied to lookup table on a form that has a tab control under it.  On the first tab, depending on the record the user moves to, I want to take the Unit Number of that record and put it into the Unit drop down at the top of the form.  No problem here.  Depending on the tab the user then clicks on, I use hidden columns from the Unit dropdown to filter and highlight, etc.  This works fine if the user actually clicks the Unit drop down at the top of the form and selects the unit.  Everything positions fine so my references to say cboUnit.column(3) works.  

But if I programmatically put the unit # in, the control does not move/update and hidden columns are incorrect.  I know I can do a Requery of the drop down control after I stuff the value into it, but I need it to be positioned on the Unit # the person selected on the first tab.  And I need to have the other rows/records in the drop down available for selecting via the drop down arrow (I don't want to say Where Unit # = F22 in the source of the drop down so only one value available in the list.)  Hope that makes sense.  Thank you, John

__._,_.___

---

Posted by: sbormail@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

.

__,_._,___