Problem putting expression on control source in Access 2003

  • Thread starter Thread starter Michael San Filippo
  • Start date Start date
M

Michael San Filippo

I have a form that was working beautifully in access 2002 and below. What I
have is a control source on a textbox set to something like this

=DSum("dblbalance","checkreg")

However, now it seems to get stuck in a loop and keeps refreshing the form.
I cannot figure out how to fix this problem. Any ideas?

When I remove this is works fine.

I compiled the code - no problem there, checked references - no problem,
converted it to Access 2002-2003 format - didnt work also I reimported all
objects into a new shell and added all references needed.

As soon as i run the Database on a comp running Access 2002 it works fine,
but running it on 2003 doesnt.

This happens when you have any expression put in there. i even put

=""

Help ;-)
 
My first guess would be that something is corrupted in the textbox. Try, in Access 2003,
deleting and recreating the textbox.
 
Then my second guess is that something in your References got messed up. Open a code
window (Alt+F11) and go to Tools|References. Compare what is checked with the system that
does work. Also, are any listed as "Missing"?
 
Back
Top