Update RowSource or a cbobox

[AndyEduardo]

Hello! Thanks for your attention.

I have the form Invoice, and inside it there is a subform name
Invoice's Details, in the form Invoice I select one costumer then i
the event AfterUpdate of the form's cbo the rowsource of the cbo in
wich I select the products in the subform updates with the product
agreed (these are stored in the table Products by agreement).

Suddenly I need to add one product agreed related to the costume
selected in the form, the point is this......I want later of thi
action (add product), the list of the cbo of the subform update
without updates the cbo in the for

 

[Michel Walsh]

Hi,


ComboBoxControl.RowSource = ComboBoxControl.RowSource


will requery the combo box row source. The code assume your run in the same
level of parentage than the control you try to reach. You have to use the
right syntax if you try to reach a control in the main form while the code
is in the subform, or vice-versa. See
http://www.mvps.org/access/forms/frm0031.htm


Explicitly force an update for each combo box you wish, in the AfterUpdate
event of the critical control, as example.


Hoping it may help,
Vanderghast, Access MVP