Combo Box feeding other combo boxes

[Flanders]

Hi,

I have a form with a stock list. One field is [Dealer Allocated] so stock
can be allocated to a specific dealer - this is a combo box (combo1) for
single allocations.

I now also want to be able to update this combo box for several records in
bulk. I thought I would do this by having a second combo box in the footer
of the form which the user selects the dealer from and then clicks a button
which looks for first record without dealer allocated and updates the value
of combo1 to the value of combo2. This would then be enclosed in a Do Loop
for specified number of records.

I cannot get combo1 to update to the value of combo2 at the moment. Any
help/advise/better ideas would be appreciated !!!

Thanks

 

[Arvin Meyer [MVP]]

Have a look at this sample database showing how to do this. It uses list
boxes, but the code and method is the same.

http://www.accessmvp.com/Arvin/Combo.zip