HELP !! Combo box to feed other combo boxes

F

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
 
O

OldPro

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

I'm having a hard time envisioning this. A stock list is a list of
stock found in a warehouse. What would a [Dealer Allocated] field
do? If each record represents one classification of stock, with the
quantity thereof, then how could it show allocation of various
quantities to the various dealers? Your solution doesn't shed light
on what you are trying to do either. What are the underlying tables,
and what are the fields in those tables? What is the value that you
are trying to store?
 
F

Flanders

Hi,

Ok sorry about that - more detail required !!
This is for a telecoms company who sell top up vouchers to dealers who sell
them on to customers. This database is to keep track of stock, which dealers
they have been 'sold' to and to create invoices for the dealers. There are
two tables involved one holding all possible dealer names and one holding all
the stock items with an extra field to hold the dealer allocated ID. The
dealer ID is selected from combo box and stored in stock table. Invoices are
then generated from this.

The problem is at the moment each voucher has to be allocated one at a time
in my stock list form and I want to be able to 'bulk' allocate 10 or more at
a time as some dealers take up to 100 in one go !

Is that better ?!

Thanks

OldPro said:
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

I'm having a hard time envisioning this. A stock list is a list of
stock found in a warehouse. What would a [Dealer Allocated] field
do? If each record represents one classification of stock, with the
quantity thereof, then how could it show allocation of various
quantities to the various dealers? Your solution doesn't shed light
on what you are trying to do either. What are the underlying tables,
and what are the fields in those tables? What is the value that you
are trying to store?
 
F

Flanders

- More info...

The stock list actually lists each individual item separately, as they are
all coded with specific serial numbers which I need to keep track of ! :O)

OldPro said:
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

I'm having a hard time envisioning this. A stock list is a list of
stock found in a warehouse. What would a [Dealer Allocated] field
do? If each record represents one classification of stock, with the
quantity thereof, then how could it show allocation of various
quantities to the various dealers? Your solution doesn't shed light
on what you are trying to do either. What are the underlying tables,
and what are the fields in those tables? What is the value that you
are trying to store?
 
O

OldPro

- More info...

The stock list actually lists each individual item separately, as they are
all coded with specific serial numbers which I need to keep track of ! :O)



OldPro said:
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
I'm having a hard time envisioning this. A stock list is a list of
stock found in a warehouse. What would a [Dealer Allocated] field
do? If each record represents one classification of stock, with the
quantity thereof, then how could it show allocation of various
quantities to the various dealers? Your solution doesn't shed light
on what you are trying to do either. What are the underlying tables,
and what are the fields in those tables? What is the value that you
are trying to store?- Hide quoted text -

- Show quoted text -

That clears things up substantually. It seems like there should be
another table with the different product classifications, unless you
really only have one product. I am still having a hard time
envisioning vouchers laying around on some dusty shelf in a warehouse,
waiting to be sold, or why a voucher would have a serial number.
Never-the-less I believe that I can help.

First, you will need a form in which to create the invoice. A lookup
field should supply the dealer information. This can be done by
either linking the form to the dealer table, and using a combobox to
lookup the dealer, or through visual basic code. Second, you will
need a method of selecting individual items, or a range of items to
sell to this dealer. One way, is to use a listbox, where the user can
select multiple items at one time, and a button that then transfers
the selected items to a second listbox that will serve as the detail
for the invoice. Another way is to have two textboxes into which the
user puts the beginning and ending serial numbers (assuming they are
contiguous). The textboxes could also be comboboxes where the user
selects the first and last serial numbers from a list. Both of these
methods will require some coding: at the moment, I don't see a way to
do this without some coding. The skill level required is
intermediate.
 
F

Flanders

Hi, thank you for that. The vouchers actually sit in a cabinet !! The
serial numbers are used to 'top-up' with - user enters this into their phone
to top up their prepaid mobile, which ensures vouchers are only used once !

There is a table holding the stock classifications as there are different
values of top-up card (£5, £10, £20) plus the Sim cards are included in this
stock list which have the sim number as the serial number.

I have done some coding before so am fairly comfortable with it - its just
knowing what code to actually use !!

Thanks

OldPro said:
- More info...

The stock list actually lists each individual item separately, as they are
all coded with specific serial numbers which I need to keep track of ! :O)



OldPro said:
On Dec 18, 6:10 am, Flanders <[email protected]>
wrote:
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 !!!

I'm having a hard time envisioning this. A stock list is a list of
stock found in a warehouse. What would a [Dealer Allocated] field
do? If each record represents one classification of stock, with the
quantity thereof, then how could it show allocation of various
quantities to the various dealers? Your solution doesn't shed light
on what you are trying to do either. What are the underlying tables,
and what are the fields in those tables? What is the value that you
are trying to store?- Hide quoted text -

- Show quoted text -

That clears things up substantually. It seems like there should be
another table with the different product classifications, unless you
really only have one product. I am still having a hard time
envisioning vouchers laying around on some dusty shelf in a warehouse,
waiting to be sold, or why a voucher would have a serial number.
Never-the-less I believe that I can help.

First, you will need a form in which to create the invoice. A lookup
field should supply the dealer information. This can be done by
either linking the form to the dealer table, and using a combobox to
lookup the dealer, or through visual basic code. Second, you will
need a method of selecting individual items, or a range of items to
sell to this dealer. One way, is to use a listbox, where the user can
select multiple items at one time, and a button that then transfers
the selected items to a second listbox that will serve as the detail
for the invoice. Another way is to have two textboxes into which the
user puts the beginning and ending serial numbers (assuming they are
contiguous). The textboxes could also be comboboxes where the user
selects the first and last serial numbers from a list. Both of these
methods will require some coding: at the moment, I don't see a way to
do this without some coding. The skill level required is
intermediate.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box on Continous form 1
Combo Box filter 7
combo box from a query 3
Cascading Combo Boxes 1
Multiple Combo Boxes 4
Multiple Combo and Subform 4
2 Combo Boxs on form 1
Subform w/ combo boxes 2

Top