VB GoToRecord Question

[CosmicKid]

Hi all -

Probably a quick cure for this, but my VB skills are a little pathetic.
I have a form based on a table with a field that allows the user to select the primary key of another record within that table. I used a combo box to do this.

When the user dbl-clks on the field I would like the form to jump to the record selected in the field. I believe I need to use a DoCmd.GoToRecord in the On Dbl Click Event..I'm just not sure what arguments to enter to get the current value in the field to be used in the goto command.

Any insight, revelations, comments, hints, tips, witty asides, etc. would be greatly appreciated.

- CK

 

[pbaldy]

Have you tried the combo box wizard, choosing the third option, "Find a record..."?

 

[CosmicKid]

Excellent idea, but I don't want the form to switch to the selected record until the user dbl clicks on the field. Essentially, the field shows the primary key of a related record. By dbl-clicking on the field, the form will then jump to that record.

Thanks.

 

[pbaldy]

The point was that the wizard would provide you with the code. What event you put it in is up to you.

 

[CosmicKid]

That was a point I missed. All is clear now and works great. Much Thanks PBaldy!

- CK