Login

Connect
Sign in using Facebook

Text Field changed to List Box - Problems

1 reply [Last post]
peterfc's picture
peterfc
Offline
Newbie
Joined: Jan 24 2012
Text Field changed to List Box - Problems

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.

peterfc's picture
peterfc
Offline
Newbie
Joined: Jan 24 2012

I have solved the problem so help is no longer required. I created a new table containing my suppliers. On the Goods table the Supplier field has been changed to a lookup field using the lookup wizard. Now on the Goods form the Supplier field has been deleted and then re-added and appears as a choice field - or combo box. Problem solved