DoCmd.GoToRecord problem

[krymzon]

i'm pretty new to the VBA thing becuase most of my experience comes from as/400 and SQL coding, so any help would be great here.
i'm trying to creat a form in access ofcourse that works like a search tool almost. so i am going to make a combo box that has a list of names from a table, and each one has a unique id. so i set up my combo box to show only the names, but to be bound to the ID. so i need a way to be able to click on the name i want, then press a comand button that will take me to that record and display that information in a subform. so the problem is getting the sunform to go to the right record in my database when i click that button.
any help would be great, thanks in advance

 

[PHV]

Why not simply follow the combo wizard (3rd option) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[krymzon]

alrighty, i'll try that. thanks alot. like i said, i have no background in vba or access but plently in databasing so i really feel wierd approaching this new system. i hope with time i'll learn access and its little tricks

<i>there are 10 people in this world. those who know binary, and those who don't.</i>

 

[PaulF]

check out this FAQ

http://www.tek-tips.com/faqs.cfm?fid=4933

PaulF