Simple Question

[ouadad]

I have database with over 400K records and I want to go to specific records, but the "Go To" dialog box only allows me to move: First, Previous, Next, Last and New. There is no Go To Record #. Is there some trick to this?

[Bulzie]

DoCmd.GoToRecord acDataForm, "Employees", acGoTo, 7

Or you can right click inside a field/column and there are filter options there.

But You should have a combo box to allow user to select the record you want based on the value from the combo box. Usually having users scroll though all records on a form is not ideal.

[ranman256]

you can just type in the # on the record counter at the bottom, then press enter.

[ouadad]

Thanks, that was easy.