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

access97: step into problem

P: n/a
hello -
i was wondering if anyone could tell me why i cannot
step through this code. if there is "----" in field4,
then go to the next record (numloans = numloans + 1),
and grab the value in field9. why can't i step in?
any thoughts?
thanks in advance. jung.

DoCmd.GoToRecord acForm, "frmUSBCERTUNPR", acGoTo, spot
If Mid(Forms![frmUSBCERTUNPR]![Field4].Value, 2, 4) = "-----" Then
numloans = numloans + 1
totalamount = Forms![frmUSBCERTUNPR]![Field9] & " "
End If

data(numloans, 3) = totalamount

then it populates another table with totalamount.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.