Im creating a database at work relating to all the brochures that we have. I have used the cool search tool as a basis for this as it is the best thing I have found. I have one table with all my details in just the same as the orginal. I have one query set out the same as theres. What I did was copy the cool search tool to my pc and insert my query into the database so that when i typed similar information into the text box it came up in the list box. However I do not know how to get my fields to display underneath the list box like it does in the cool search tool. Please help me.
Really Big problem
- Thread starter Tj.b123
- Start date
- Local time
- Yesterday, 22:39
- Joined
- Aug 30, 2003
- Messages
- 36,157
Please don't post the same question twice:
http://www.access-programmers.co.uk/forums/showthread.php?t=157330
http://www.access-programmers.co.uk/forums/showthread.php?t=157330
Krispy1001
New member
- Local time
- Yesterday, 22:39
- Joined
- Sep 22, 2008
- Messages
- 3
Tj.b123,
You need to add a combo box in your form, use the wizard to help you make the combo box. When the wizard starts choose “I want the combo box to look up the values in a table or query” click next. Now choose the table or query that has the data that you need for your form. Next choose the fields that you want your combo box to store. (Remember the order that you choose the fields will be the order that they are saved and retrieved out of the combo box) The next window will show the fields that you have chosen and you will see a check box that reads “Hide key column” If the first field that you choose is the key in your table and you want your combo box to have it’s value you need to uncheck the “hide key column box”. If you do not your combo box will have the value of the second field that you choose for your combo box. The next window will ask you how you want to store the data. I would choose the radio button the reads “store that value in this field” then choose the field that you want to store the data.
The source query of the combo box can contain all fields you might need
to populate textboxes on a form.
It is not necessary to display all the columns, only the ones you really need to
appear in the combo box, and doing so you need to define in the combo's
Properties window how wide a column would be. E.g.: if you have 3 columns in
the source query and want display only 2, in the Properties window set the
columns' width like 1";1.5";0. As you can see, the first 2 columns
will be displayed in a 1" and a 1.5" wide space, while the other one won't be visible because of the 0" setting.
You can still refer to all 5 columns in the combo's record source, and even
copy data from there. columns. Let’s say the you have a textbox on your form called Text2, and want to get the company name for a selected record in the combo. In the combo box the data will be stored in columns as followed: “column(0) stores the first field that you choose for your combo box to store, column(1) stores the second, and column(2) stores the third. Lets say that the data that you want to be stored in Text2 is in the second column in your combo box. You can set the Text2 value by typing into the control source line =nameOfComboBox.Column(1) (Example: =Combo1.Column(1)).
You can do this with more then one text box; all you have to do is refer to
the correct column number.
Hope this helps,
Krispy1001
You need to add a combo box in your form, use the wizard to help you make the combo box. When the wizard starts choose “I want the combo box to look up the values in a table or query” click next. Now choose the table or query that has the data that you need for your form. Next choose the fields that you want your combo box to store. (Remember the order that you choose the fields will be the order that they are saved and retrieved out of the combo box) The next window will show the fields that you have chosen and you will see a check box that reads “Hide key column” If the first field that you choose is the key in your table and you want your combo box to have it’s value you need to uncheck the “hide key column box”. If you do not your combo box will have the value of the second field that you choose for your combo box. The next window will ask you how you want to store the data. I would choose the radio button the reads “store that value in this field” then choose the field that you want to store the data.
The source query of the combo box can contain all fields you might need
to populate textboxes on a form.
It is not necessary to display all the columns, only the ones you really need to
appear in the combo box, and doing so you need to define in the combo's
Properties window how wide a column would be. E.g.: if you have 3 columns in
the source query and want display only 2, in the Properties window set the
columns' width like 1";1.5";0. As you can see, the first 2 columns
will be displayed in a 1" and a 1.5" wide space, while the other one won't be visible because of the 0" setting.
You can still refer to all 5 columns in the combo's record source, and even
copy data from there. columns. Let’s say the you have a textbox on your form called Text2, and want to get the company name for a selected record in the combo. In the combo box the data will be stored in columns as followed: “column(0) stores the first field that you choose for your combo box to store, column(1) stores the second, and column(2) stores the third. Lets say that the data that you want to be stored in Text2 is in the second column in your combo box. You can set the Text2 value by typing into the control source line =nameOfComboBox.Column(1) (Example: =Combo1.Column(1)).
You can do this with more then one text box; all you have to do is refer to
the correct column number.
Hope this helps,
Krispy1001
Similar threads
