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] - 17 Dec 2007 16:49 GMT
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

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
> Hi,
>
[quoted text clipped - 17 lines]
>
> Thanks