ADP bound form - force save record, recordsetclone not populating after requery

B

Br@dley

I am a developer for a small software company. We have encountered the
following problem in Access2000 (ADP/SQL Server 2000)

(1) The REFRESH method for forms in an ADP does a REQUERY and does not
just save the current record.

How can we force a record to be saved on a bound form in an ADP?

We devised a method of storing the ID of the current record, requerying
the form, then use a RECORDSETCLONE to find the ID and then move back to
the initial record on the form. However, then we encounter the next
issue.

(2) When using a RECORDSETCLONE (as used in MS examples of how to search
and move to a record on a form using VBA code) after a REQUERY the
resulting recordset does not contain all the records. Doing a search for
a record that isn't within the first 100 or so records fails. If you
trace the code a line at a time it works.

How can we make sure the RECORDSETCLONE contains all records after a
REQUERY?
--
regards,

Bradley

A Christian Response
http://www.pastornet.net.au/response
 
G

Guest

you dont need to refresh as long a the user click out of the field the data
will safe

Marcel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Requery and bookmarks 7
Control a form with a subform? 5
Moving To A Record in Access Project 1
ADP Form won't save data in Access 2003? 2
Access 2000 requery on non-bound control 3
Moving a bound form to a record 2
Requery of Accumulator Control on Form 1
Subform requery returns to first record 4

Top