ADP Form Refresh

  • Thread starter Thread starter Wags
  • Start date Start date
W

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
 
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.
 
On your resync options of the form, you must use a select
statement with all the columns name included. Do not use *
 
Back
Top