Changing the source data of a combobox while maintaining current functionality

[TKTheKid]

Hi everyone,



Please see formTicketMod in the attached database. To the very right of that form I have text boxes and comboboxes in place so the user can have that data added to table tableWarehouseData.

I would like to make a slight change though I'm not sure how to go about it. How do I make it so that clicking commandAdd still does the same thing it does currently, but instead of the user selecting a UPC in comboAddUPC, they select a style, color and size just like combobox cboStyleNo?

Thank you very much!

Tony

[June7]

Not understanding what you need. Why select style, color, size? Those fields are not in tableWarehouseData.

[TKTheKid]

Oh, I'm sorry. I should have been more clear. You are correct, but the Articles/UPCs are in both tableWarehouse and tableKWIData, so the style, color and size can be selected from tableKWIData some way, right?

[June7]

You mean like in the combobox on the left side of the form?

Still don't know why you need to select those attributes under 'Adding Tickets'. Nor why clicking commandAdd would have anything to do with selecting those attributes.

[TKTheKid]

Yes, exactly like the combobox on the left side. And it's really just for the user's convenience. It'd be much easier for the user to look up the style, color and size than the article/UPC.

[June7]

I am totally lost. If Add Ticket means add a brand new ticket to tableWarehouseData, why would you need to select any info from tableKWIData? Are you actually wanting to select ticket existing in tableKWIData and save it into tableWarehouseData?

[TKTheKid]

I apologize again. Let me try to explain it better after two failed attempts, haha.

The ticket and location will be entered by the user. Those could be practically anything - numbers, characters, whatever.

The combobox comboAddUPC in place DOES select the articles from tableKWIData as its source, but the command button commandAdd does indeed add that data to tableWarehouseData though.

So the command button already does what I would like it to do. It adds a new record to tableWarehouseData - the ticket, the location, the article and the quantity. That DOES NOT need to change.

I would just like combobox comboAddUPC on the right to be like combobox cboStyleNo on the left in that it is still tied to the article but the combobox itself displays the style, color and size for the user to select.

I hope I made this a bit clearer.

Thank you for your patience June.

Tony

[TKTheKid]

Was anyone able to take a look at this?

[June7]

So UPC is synonymous with Article?

Sounds like you just need to replicate the properties of the Style/Color/Size combobox in the UPC combobox.

Why is the Quantity textbox bound? If you enter a value then the record will be altered.