Automatic Scrolling of Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a form that validates certain values, I am struggling to get the form
to scroll through the records automatically and then stop when ([IDOrig1) <>
([IDFinal]) with a message. If no errors exits, it must scroll thourgh to the
end of all the records and then give a message that the process is complete.

Can anyone please suggest what to do, I get errors the whole time.

PLZ PLZ PLZ !!!
 
Why not just build a query to do pop up all the problem records? You could
create a form based on that query if you want and then the user would only
see the problem records and they could fix them there on the screen.

Or, simply apply a filter to your form. This filter could be turned on or
off with a button.

No "scrolling" and "stopping" needed.
 
I did think about it, but the function of the form is to validate ID Numbers
using about 48 different complex calculations, this has to be done in the
form,

then if the end result is not the same as the original value, it must stop
and tell you to change it.

I also have a second form I am having problems with, It checks and then
changes certain values of fields according to certain values in different
fields and settings on the form, there is 109 fields.

I just use the following :

ON Current :

Change all fields, goto next record, this repeats the oncurrent event, but
everytime, after 321 records, i get runtime error 2105 Can't go to specific
record ????

Rick B said:
Why not just build a query to do pop up all the problem records? You could
create a form based on that query if you want and then the user would only
see the problem records and they could fix them there on the screen.

Or, simply apply a filter to your form. This filter could be turned on or
off with a button.

No "scrolling" and "stopping" needed.

--
Rick B



attie said:
Hi,

I have a form that validates certain values, I am struggling to get the
form
to scroll through the records automatically and then stop when ([IDOrig1)
<>
([IDFinal]) with a message. If no errors exits, it must scroll thourgh to
the
end of all the records and then give a message that the process is
complete.

Can anyone please suggest what to do, I get errors the whole time.

PLZ PLZ PLZ !!!
Click to expand...
Click to expand...
 
Back
Top