Dropdown menu...

[phatus]

hi im near finishing my project.... im in my last step.... making a drop down menu "but" automatically the full information will appear.. i know now how to make the drop down menu...

example in the drop down theres 5 name, namely, A,B,C,D, and E..... when i select name A all the information in the field about A will appear in the form...

Question: what do you call that kind of command? i know its possible because ive seen 1 in ms access.. he just put the ID number and all the information appeared in the table.. or if you have any link in the step by step guide pls do...

thanks in advance...

[royUK]

Use VLOOKUP combined with Data Validation. See the example here

[alansidman]

Look at the three videos on DataPig on combo boxes. You will have to scroll down a bit.

http://www.datapigtechnologies.com/AccessMain.htm

Alan

[phatus]

thnx i think i have all the needs there i hope its 2007 guide ^ ^..
its 2003 do you have a link for 2007 sir?

[royUK]

thnx i think i have all the needs there i hope its 2007 guide ^ ^..
its 2003 do you have a link for 2007 sir?

Which link are you referring to? My example will work in any version of Excel

[alansidman]

DataPig has not issued a 2007 version of its videos. The same principles apply. You will have to convert the steps to open certain windows by using the 2007 Ribbon versus the 2000 tabs. If you are unsure of how to do that, download this cheat sheet.

http://office.microsoft.com/en-us/ac...in=HA010229584


The differences are minor and should not affect how you achieve your goals.

Alan

[split_atom18]

Which link are you referring to? My example will work in any version of Excel

This is the Access Tables and Database thread.

What would be best is for him to Learn some ADO/SQL and use the selection from the combo box to select the record and populate the fields from the data stored.

Something like below:

Please Login or Register  to view this content.

Hope this helps,

Dan

[phatus]

thanks for the help very much appreciated Problem solved