Forum Home
Press F1
Thread ID: 38668	2003-10-14 19:08:00	Access 2000	Ron Bakker (356)	Press F1

Post ID	Timestamp	Content	User
183255	2003-10-14 19:08:00	Greetings I am making a database for tyre sizes. I want to input the data using a form, which I have made. A lot of the data is reacurring so in my form in the field I changed one of the properties so the field has a list box so that I can click on one from the list to speed things up. After I did that & then clicked on the box but it would just turn up blank. Even though for example in the brand name field on the table I have several brands listed.	Ron Bakker (356)
183256	2003-10-14 19:52:00	Have you bound the list box control to the correct field in the table? It doesnt sound like it. Check the properties of the list box and it should show you which field its bound to. B.	Barnabas (4562)
183257	2003-10-15 08:53:00	First I shall correct myself. I mean combo box not list box. but they are definitly bound. When I input data in the form it shows up on the underlying sourse table. But what I cannot seem to change is the the combo box to show a list of the values that I have just typed in. "Sigh" But thanks for your post anyway Barnabas	Ron Bakker (356)
183258	2003-10-15 22:26:00	Hi Ron, if you want to add items to the list, you will need to change the LimitToList property to No and use the OnNotInList event procedure to add items to the list.	parry (27)
183259	2003-10-16 18:35:00	Well I gave that a go but no luck. Thanks again.	Ron Bakker (356)
183260	2003-10-16 21:55:00	Do you know how to use VBA? You could also do this with a macro. See here (www.moretools.com) which gives a line by line explanation of using this event. You right click the combo box and select properties then the Event tab and in the NotInList event click the elipsis (three dots) then choose code. hth Parry	parry (27)
1