Tech Support Forums - TechIMO.com - View Single Post

Turnip12 · March 5th, 2003, 03:52 PM

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.

March 5th, 2003, 03:52 PM	#1 (permalink)
Turnip12 Member Join Date: Nov 2001 Posts: 177	VBA GoToRecord, or Find? 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. Last edited by Turnip12 : March 5th, 2003 at 04:12 PM.