Thank you for responding. I tried replacing
Forms.frm_Sheet_Information.sfrm_Treatment_Data.Unit.Requery
with
Me.sfrm_Treatment_Data.FORM!Unit.Requery
and got a message saying Compile error: Invalid use of Me keyword. Since you said it had to me the name of the control, I then tried...
Hello - If you go to the design view of the form (at least in Access 2002), right click on the control you want to turn red, and choose conditional formatting. You can then enter the conditions needed and choose the format for red text. Hope this helps.
Julie
Hello,
I am a novice at using VB. I took a class a few years ago and have not used it since. I am using Access 2002 and I am trying to requery a field in my subform after a field in my main form is updated. I figured an AfterUpdate Event Procedure would be appropriate, but not quite sure how...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.