How to go to a record on a form

[projecttoday]

I need to "reset" a form after running some append queries from a command button on it. If I do:

gocmd.GotoRecord ... recnum

it takes me to the record that is numbered recnum starting from the beginnning of the query. What I need is to go a record with a specific key value (which happens to be the record it is on!) Is there a way to do this? If not, is there a way to access the current record number?

Robert

 

[PHV]

Have you tried Me.Refresh ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[projecttoday]

I THINK that's it. Knock on wood this time. Thanks for your help, PH.

Robert