Go To Record

[Patsyoyo]

Hi,
I am trying to create a control on a form that would allow me to choose a record to go to based on a choice in a combo box. In other words, it's a database of projects, so I would like to be able to list the projects, choose one, and go to that record. I can only figure out how to go by record number, but since I have no way of knowing which number is which project, it does not help much.

Thanks for any help.
Linda

 

[Axis]

The record number is a dynamic indicator that will change with deletions or additions to your table, so you can't use it to regularly find records. You should have a field in your table that is a unique identifier, something like Project Number, that you should use instead. If you list that field in your combo box (you can have multiple columns), you can refer to it in either VBA or a macro (using the FindRecord action).

This is a quick explanation, so let me know if you need more details.