C
Clifford Bass
Hi Mari,
Oops, the error you are getting is my fault. The line have the second
! changed to a period:
Me![Label-Sub].[Form].Requery
You are right, the data should be there, assuming the insert is
working. Time to do some debugging. Place a break point on the first code
line after the Dim statements and run the process. It will stop and
highlight the line with the break point. Press Shift-F8 repeatedly and see
what happens. You can inspect the values of the various variables by
hovering your cursor over them. You could also temporarily disable the first
SetWarnings line by placing an apostrophe in front of it so you do get
messages. That might also give you a clue about why it is not working.
Hope that helps,
Clifford Bass
Oops, the error you are getting is my fault. The line have the second
! changed to a period:
Me![Label-Sub].[Form].Requery
You are right, the data should be there, assuming the insert is
working. Time to do some debugging. Place a break point on the first code
line after the Dim statements and run the process. It will stop and
highlight the line with the break point. Press Shift-F8 repeatedly and see
what happens. You can inspect the values of the various variables by
hovering your cursor over them. You could also temporarily disable the first
SetWarnings line by placing an apostrophe in front of it so you do get
messages. That might also give you a clue about why it is not working.
Hope that helps,
Clifford Bass