By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,357 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

Stop current record from moving to another record

P: n/a
I input data into two textboxes on Form1 which returns three records
into Form2.

I then Print record 2of3 using criteria from Form2.

stLinkCriteria = "[PartNumber]= '" &
Forms![frm_Edit_Completed_I&T_Sheet]![txtPartNumber] & "'" & " AND
[MacPacNumber]= '" &
Forms![frm_Edit_Completed_I&T_Sheet]![txtMacpacNumber] & "'" & " AND
[DiscSerialNumber]= '" &
Forms![frm_Edit_Completed_I&T_Sheet]![txtDiskSerailNumber] & "'"
stDocName = "rpt_Serialized_Wheel_Assy_RePrint"

DoCmd.OpenReport stDocName, acNormal, , stLinkCriteria

All goes well except Form2 always advances to the first record and I
want it to stay on record 2.

What do I have to do?

Thanks, RICK

Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.