Issue with combobox autofill

[coffeeman]

I have created a form that based on a selection in an item code combo box, I have roughly 10 items that autofill. This works fine.

One of the fields that autoupdate is FILM. The issue I am having is, I want the FILM to update another field, FILM LOT CODE. I created a combobox and can get the FILM to Autofill the FILM LOT CODE but it is based only on SELECT. Is there another option besides SELECT that will autofill the FILM LOT CODE field. This way that when the FILM is autofilled by the ITEM CODE selection, it will then autofill the FILM LOT CODE.

Any ideas?

Thanks

 

[boblarson]

Not quite reading you there. How exactly are you "auto filling" the Film Lot Code? It is likely you can just include all fields in your combo and keep them hidden but set the control sources to the applicable combo columns.

 

[coffeeman]

I may not be using the correct terms, but I am 'autofilling' the other fields based on a combobox called cboItemCode. This combobox pulls data from a table (tblItemCode). This table has everyone of our customer's specific materials on it. When the combo box item is entered or selected, it pulls from there (I have the code written out for what each column will autofill). The Material Lot Code is not on this same table. It is on a separate Receiving Table that gets the Material Name, Date Received, Lot Code, Quantity, etc. I also have a field named "current lot code" so the db knows what lot code is currently being used.

That being said, I am trying to use another combobox and I have it working when I SELECT the material to update the material lot code. I need it to be able to fill the material lot code based on the entry that is being autofilled in the material, not SELECTed only.

Makes more sense?

 

[coffeeman]

Actually, I figured it out. I just added some more codes to the item code table, but made the reference combo box be the corresponding materials combobox.

Thanks for the help.