Update Query

[chuckdarwin]

I created this query looks like it should work to me but it does not

Before i added the Criteria it worked like a charm but as soon as I added the Where Statement it doesnt update anything. Can someone tell me what i dod wrong ??


UPDATE Broods SET Broods.[Produce Fed to Date] = [Forms]![Feed Logging]![Producetxt]+[Broods]![Produce Fed to Date], Broods.[Protein Fed to Date] = [Forms]![Feed Logging]![Proteintxt]+[Broods]![Protein Fed to Date], Broods.[Last Fed] = Date()


WHERE ((([Forms]![Feed Logging]![Combo0])=[Broods]![Bin ID]));

[ranman256]

so if you paste this sql into a query and run it , does it give an error?
if no error, does the query tell you it will modify N records?

[chuckdarwin]

No error at all It pops up the "you are about to update window" and then says it updated zero records when it should be updating one record the Bin ID selected in the combo box.

[chuckdarwin]

When i remove the Where statement it updates all the records displayed in the combobox dropdown which is what i would expect.

[chuckdarwin]

changed it up a little no difference.

UPDATE Broods SET Broods.[Produce Fed to Date] = [Forms]![Feed Logging]![Producetxt]+[Broods]![Produce Fed to Date], Broods.[Protein Fed to Date] = [Forms]![Feed Logging]![Proteintxt]+[Broods]![Protein Fed to Date], Broods.[Last Fed] = Date()
WHERE (((Broods.[Bin ID])=[Forms]![Feed Logging]![Combo0]) AND ((Broods.Retired)=False));

[chuckdarwin]

I changed it to a select command and renamed the combo box tag to see what it was resolving
it resolves zero data so i checked my data
retired flag is false on all records
I set it to show me what the combo box was resolving as and it was null

Not sure why shouldn't ![Feed Logging]![Combo0] give me the value selected in the combo box ?

[John_G]

Not sure why shouldn't ![Feed Logging]![Combo0] give me the value selected in the combo box ?

Possibly because your combo box isn't set up properly. How many columns are in the combo box, how many are visible, and which column of the combo is the Bound Column?
![Feed Logging]![Combo0] will give you the bound column value by default.

Typically, a combo box has a hidden (usually numeric) column that is also the bound column, while the combo box displays related text (name, description, department, etc.)

[ssanfu]

Any chance you would post your dB (just a few records for testing) so we can see what you actually have?
Make a copy of your dB, delete records leaving a few, do a "Compact & Repair" and zip it.

[June7]

I offer same suggestion as in your other thread https://www.accessforums.net/showthread.php?t=70232