How to Open form and jump to certain record?

[behnam]

Hi all,

I have a form called Estimates and a variable called IDHolderDisapprove which stores an int. I want to open the form and go to the record with the ID equal to that stored in the variable. I tried the code bellow but its not working. Can someone help me, thanks.



[code]DoCmd.OpenForm "Estimates", , , "ID = IDHolderDisapprove"[\code]

[ranman256]

The variable must be outside the dbl quotes to resolve to a value.
"ID = " & IDHolderDisapprove

[behnam]

This does take me to the correct record in the form, but dosent allow me to move to other records using the navagitation tool. Is there away to go to the record i want without filtering all the other records out?

[ranman256]

It opens it filtered.
To move about other records ,simply turn OFF the filter (the funnel icon on the toolbar)