Prev: Alert user to check the filed when it is final
Next: checking duplicate values on data entry
From: Afrosheen via AccessMonster.com on 2 Feb 2010 13:58
True. I did change it and it now works perfectly. Again, I thank your for
your help with in the last week or two. Your help has been valuable. I've
learned a lot. Now I hope I don't get the CRS syndrome.

Talk to you on the next problem..

John W. Vinson wrote:
>>sql6 = "Update tblMain set super1 = Null where super1 =""" & txtAssist1 & """
>>And (tblMain.SupMan) = false"
>[quoted text clipped - 3 lines]
>>supervisor not the employee. The sql6 statement is for both. Maybe I should
>>just use the first part of the sql6 statement.
>
>I would guess that sql6 shouldn't be looking at SupMan *at all*; the records
>that you want to update are those who have sdr555 as a supervisor, and I'm
>guessing that you want to do so whether the employee whose record you're
>updating is a supervisor or not.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201002/1

First  |  Prev  | 
Pages: 1 2 3 4 5 6
Prev: Alert user to check the filed when it is final
Next: checking duplicate values on data entry