Change Appearance of Form if Yes/No Field is Populated

[Richie2837]

I've got all this code in place, but am still getting the "Compile Error. Method or Data Member Not Found" message whenever I click the LoneWorkerCaution tick-box. VBA opens with Private Sub LoneWorkerCaution__AfterUpdate() highlighted in yellow.

 

[GaryPanic]

whats the name of your tick box ??

 

[Richie2837]

LoneWorkerCaution

 

[GaryPanic]

can you copy and paste code - ta

 

[GaryPanic]

can you also do a screeen print of you main form in design mode
ta

 

[Richie2837]

This is the entire code behind the form in case anything is conflicting

 

[Richie2837]

screen shot

 

[GaryPanic]

do you have a version thats not split fe/be

as this is mad - this should work (as per my little db)

 

[Richie2837]

I've e-mailed it to you as its too big for the Forum size limitations

 

[GaryPanic]

will revert (got 2 do some real work )

 

[GaryPanic]

what version of access

 

[boblarson]

what version of access

This is a guess from me (I just wanted to) but I think it is Access 2000, based on the icon on the form. Let me know if I'm wrong.

 

[GaryPanic]

Bob - I have 2000 and I cannot get this to d-load

THe code I have used works a charm on the sample d/base I made
all thats happens copy and past change fieldnames etc (which is how i did the sample)
your knowledge outstrips my by a very large factor - and as i cannot download this db - could you shed some light on this ....

Richie would be greatful

 

[boblarson]

Gary - I'll PM you and you can forward the email to me and we can see.

 

[GaryPanic]

Richie

see my personal post

its possible a zip problem - do what Bob suggest - resend to me at my nuts account -

If you get this in time -= might do it over the w/end