ADP Form Refresh

[Wags]

I have an A2K ADP w/SQL2K BE. I have a form based on a
stored proc that I need to be able to perform a data
refresh on, while keeping the focus on the current
record. However, when I use FormName.Refresh or .Requery,
it always goes back to the first record in the recordset.
I have tried setting the resync command property of the
form to use the where clientID = ? (clientID is my primary
key), but that didn't help. Any suggestions?

Thanks,
Wags

 

[BJ Freeman]

I use a quick and dirty way. I open the form rt click on the field and
Filterby.
then I go the form design mode and get the string from the filter.
then after I do a requery I use the string to set the record using the
filter in code.

 

[Jaime E. Maccou]

On your resync options of the form, you must use a select
statement with all the columns name included. Do not use *