Compile Error - Referencing Fields not present in Form

lopiner

Registered User.
Local time
Today, 21:09
Joined
Jan 21, 2010
Messages
29
Hi to all

I have decompiled my file to clean up old compile states but i have a problem now. I have several references in VBA to fields that are "pulled" from the rowsource but are not actually a inserted field in the form. This way i don't have lots of invisible fields when i just need the value and don't need the user to see it. The problem is that now when i try to compile the VBE gives me an error as the field doesn't exist. Is this normal and is there a way of overcoming this?

Thanks for any reply
 
Last edited:
DCrake

Thanks for the reply. I'm using Access 2003
 
Hi,
I'm still having this problem.
I have a form with a record source that includes a text field named "TextField" but this field is not the control source for any object in the form. I normally can check the value of this field in VBA that appears with just one property that is .value
I cannot figure it out but from time to time this type of fields are treated as missing ones and i cannot run my codes or debug. Can anyone help?
Thanks in advance
 

Users who are viewing this thread

Back
Top Bottom