I'm trying to use a combo box to skip directly to a specific record. Apparently if you have Access build it for you, it'll use recordsets and the Find method. Unfortunately I'm trying to use a combo box on the startup form and go to specific record on another form. So far I've been messing arounf with both DoCmd.GoToRecord and rstVariable.FindFirst, without luck on either one. Anyone have any suggestions? Or is there a completely different way to do this? So far it's looking like a need to use a number to skip to a certain record with DoCmd.GoToRecord, is this correct? so the code would be something like:
DoCmd.GoToRecord acDataForm, "FormName", acGoTo, #
So it's not really going to work for me with the combo box idea right?
And when I tried the recordset approach I wasn't getting any luck, I tried copying the code exactly as Access created it, first using DoCmd to open up the form I was going to, no luck. Any input would be appreciated. Thanks.
hardware
prices 
