Cycling through Records 1

[iXPhound]

Hi all, have a quick question. I have a continous form. I would like to cycle through all the records in this form, find out if txtShift.value = "A". If it does, I would like to have my checkbox, chkRDO.Value = True. So far I can get this to work on the initial record when the code is placed in Form_Load, however it stops at the first record. What should I do to have the code cycle through all of the records and check the value of txtShift? TIA!

 

[ScottCybak]

Rather then having it manually scroll through records, what if you ran an update query onLoad. You could either build the query and save it, or, run an sql command via vba.

If you want it to go seamless without any prompting, before you fire the query.

DoCmd.SetWarnings (False)
'Code to run update query
DoCmd.SetWarnings (True)

Always remember, when turning off warnings, to turn back on immediatly after! As this will stay in effect throughout the entire use of the dbase

HTH