creating auto suggestions

[nawara]

hey ..
i am entering my suppliers in forms. i hold information such as name of supplier ,telephone number and adress
i was wondering if there was a way that i could basically just type the name and then the rest of their information telephone number and adress could automatically be entered..or even if there was a suggestion list?
if there is a way could anyone tell me how and what to do?
thank you
Regards Noor

 

[Luddite Lad]

You could use a Combobox that contains all your suppliers and then from there use that selection to populate a number of text boxes with the supplier details.

Check the Sample DB

 

[nawara]

You could use a Combobox that contains all your suppliers and then from there use that selection to populate a number of text boxes with the supplier details.

Check the Sample DB

hey.. thank you for your reply..
its helped me alot
i created a combo box.. but the only feild that is apearing is the name of the supplier.. the other feilds (telephone number, adres) are not showing :s
this is what i did:-

forms tab> design view on my suppliers form> combo box tab on the tool bar> clicked I WANT THE COMBO BOX TO LOOK UP VALUES INTABLE OR QUERY>clicked the table desire (suppliers table in query)>seleccted 3 feilds name, adres telephone number>next> clicked REMEMBER THE VALUE FOR LATER USE>next> save

 

[Luddite Lad]

When you create your combo box you have to make sure that you select all the fields that you latter want to show in the Text boxes. You don't actually have to show them in your combo though. Just remember that the columns in your combo box are numbered from Zero up.

 

[kate10123]

Your example has helped to answer my thread about filling textboxes with combo values.

Just one question in connection with this, I have used your example db as a template to test it out on my database and I can get one corresponding value when I select a value from a combo but the other two textboxes I have do not seem to link to anything.

Do you have to define telephone number or email fields anywhere so that they can link with the combo box as well?

 

[nawara]

thank you... il figure it out.. sumhow

 

[nawara]

Your example has helped to answer my thread about filling textboxes with combo values.

Just one question in connection with this, I have used your example db as a template to test it out on my database and I can get one corresponding value when I select a value from a combo but the other two textboxes I have do not seem to link to anything.

Do you have to define telephone number or email fields anywhere so that they can link with the combo box as well?

yh thas the same problem i am having
only one feild is showing tho the rest arent

 

[kate10123]

How strange, I have looked at the complete SQL statement he uses in the example and mine is identical too!

 

[nawara]

How strange, I have looked at the complete SQL statement he uses in the example and mine is identical too!

i know... il let u know if i find the answer out!

 

[maxmangion]

Hi,

I would suggest doing this at query level and then simply base your form on the query. In the attached sample when you go to the query which i created as soon as you enter a supplierID the other fields related to suppliers will populate automatically.

 

[Luddite Lad]

All you need to do is follow the Combo Box wizard. Make sure that you select all the information you want to show in the unbound Text Boxes, that will be related to your selection. Then when it comes to to point where the wizard shows you all the columns that will be shown in your Combo, set all the superfluous columns to zero width (you can also do this in the properties of the combo latter) and note the column count for each piece of information.

IE. the index will (usually) be column0, the display information will be Column1, and subsequent information will be numbered accordingly.

Now just make the appropriate column the source for each text Box.

But as maxmangion has pointed out there is always more than one way to skin a cat. This is the just the way I would do it

 

[kate10123]

i know... il let u know if i find the answer out!

Hey I have finally managed to get mine working! I was using Access 2007 so didn't have the combo box wizard. When I opened my database in Access 2003 I created a new combo box, followed the options for looking up values from a table or query, selected all the columns I am interested in.

Then in the properties window you need to make sure 'Column Widths' is set to just show the first field.

Then as shown in the example database, reference this combo box in your textboxes to pull those hidden fields.

 

[nawara]

Hey I have finally managed to get mine working! I was using Access 2007 so didn't have the combo box wizard. When I opened my database in Access 2003 I created a new combo box, followed the options for looking up values from a table or query, selected all the columns I am interested in.

Then in the properties window you need to make sure 'Column Widths' is set to just show the first field.

Then as shown in the example database, reference this combo box in your textboxes to pull those hidden fields.

thanks kate.. i managed to get it done
Regards Noor