Combo Box update Text Box

[iisjman07]

Hi, I need help getting a text box to update when I change the value of a combo box. I currently have a table called 'PURCHASE_SERIALS' which will be used to store the serials of purchase order items. It has two fields, 'PURCHASE_ORDER' & 'SERIAL NUMBERS'. I have created a very simply form that allows the user to select the purchase order number using a combo box, and I have created a text box for the Serial Numbers. The combo box works, but I don't know how to get the text box to update to show the serial numbers from that purchase order.

Screenshots (can't post links yet, so there's a gap between the 'h' and the 'ttp'):
Form Form View:

PURCHASE_SERIALS Table Datasheet View:

Any help would be greatly appreciated

 

[boblarson]

Screenshots (can't post links yet, so there's a gap between the 'h' and the 'ttp'):
Form Form View:
PURCHASE_SERIALS Table Datasheet View:

Post the screenshots HERE, not somewhere else. Follow these instructions:
http://www.access-programmers.co.uk/forums/showthread.php?t=194680

 

[iisjman07]

My post count is prohibiting me from posting images. After this it should be large enough...

 

[boblarson]

The serial number should show if it is bound to the field that is in the table. If you are using a multivalued field you probably shouldn't and then you would use another table to store the values:

tblPOsSerialNumbers
POSerialNumberID - Autonumber (PK)
PurchaseOrderID - Long Integer (FK from Purchase Orders table)
SerialNumber - Text

Then you would use a subform on the form for this.