check box update

[Bladerunner]

I tried this last night and though my failure to explain it correctly, I, much less the person who was helping me could not understand it. Let me try again.

Am trying to update a check box (s) in one table.

Here is the sql of the query:

UPDATE tblPurchasingRecord SET tblPurchasingRecord.[Update to MS] = Yes
WHERE (((tblPurchasingRecord.[Update to MS])=No));

This Query runs by correctly pulling up those records where the checkbox = False, NO, etc.

However, it will not place a check in the checkbox to indicate the value has been changed to True, Yes, etc. There are no errors.

Does this make sense?


.

 

[llkhoutx]

TUse -1 for True, 0 for False.

 

[Bladerunner]

Tks for answering ...I have tried those values as well, -1 and 0
Thanks again

 

[Bladerunner]

I have no value in the tblPurchasingRecord to test against except the checkbox itself. I wanted to use the checkbox to tell the main update section which records need to be updated. I was using the null value in the checkbox to check against itself and then update itself.

I could put in another field into the tbl with the purpose of being null at all time for a work around.

 

[Gasman]

I am doing a similar thing for a Logged_In field, but I use True and False for the checkbox field (Yes/No) and that places a tick in those logged in. I also do similar to another table using query with same values, where I toggle the value of the checkbox and also clear the checkbox.

 

[Bladerunner]

Good evening to both of you, boy it sure has been a long day here.

TO answer your queston AccessBlaster, I use this 'purchasingtransferkey' query as a secondary query to the 'AppendPurchasingrecord' query. Once the program calls the 'AppendPurchasingrecord' query, it then calls the 'purchasingTransferKey' query immediately following,which simply checks the checkbox in tblpurchasingrecord. Those records that have been appended to another tbl are new records thus the checkboxes value should be false.This then changes the checkbox to True.

 

[Bladerunner]

Oops, forgot to tell you. I pulled up all the records (checked and non-checked) but the 7 records that needed to be checked were not affected.

I know I am doing something wrong and have gone through the purchasing table, and both queries with no results. Am going to go back through them again and see if I can see anything.

By the way, Is there a difference when the PTK is in the window, between the 'view' and the 'run' button on the bar? So far I cannot tell the difference with the exception, the 'run' button affects the Purchasing table and the view only shows you what you are going to get.I hope.

 

[Bladerunner]

Got it, It was in the form for Purchasing. Have been removing and generally reworking my files to fit what you here in the forum recommend.For some reason, the keys to initiate the query was missing in my FrmPurchasingRecord. It has been running me ragged trying to find it and I know it has been a bit of a nuisance for you. However, I do appreciate all your hardwork.

Thanks
Bladerunner