Hi John
I'm guessing cboUnit has an AfterUpdate event procedure associated with it that makes the changes you are not seeing.
Many events fire automatically only after an action in the UI, and AfterUpdate is one of these. You will need to call cboUnit_Afterupdate explicitly after setting its value.
Best wishes,
Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, 21 June 2018 08:38
To: MS_Access_Professionals@yahoogroups.com
Subject: [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: "Graham Mandeno" <graham@mandeno.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar