I started with a table and form containing a text field for my Suppliers. There are only 6 suppliers so far, but being lazy I converted it to a List Box on my form. The problem is that the Supplier field on the table, which is still a text field, is now blank and contains no data. In the design view there are no options for this field that would indicate how to modify it. So, how can my table pick up the entries used on the form? I presume that I can write a query to modify it but that feels like a sledgehammer to crack a nut.
Text Field changed to List Box - Problems
25 January 2012 - 4:33am
Text Field changed to List Box - Problems