Update query returns 0 records

[DMT Dave]

Hi Guys, i am trying something that should be so simple, running an update query to update records in the table

Paid field is Yes/No PaidDate is Date Field And InvoiceNumber is Number field

I may have 20 records with the number that the user has been prompted to enter and the number goes to txtCriteria and a paid date that the user is prompted into txtPaidDate

When i run this query it returns 0 records ?





Thank you

[Bulzie]

Said InvoiceNumber is numeric but field in forms looks like text. Not sure if that matters. But change the query to select query and see if you get records with just the Criteria for InvoiceNumber. Are you sure whatever is in that field has records in the table?

[orange]

You criteria design seems to indicate an OR operation.

(PAID and DaidDate) OR InvoiceNumber

[Bulzie]

Thought that too Orange but then saw those are the Update fields, the only criteria is the InvoiceNumber.

[orange]

OK. I see that now. An ounce of prevention.....
Thanks.

[Micron]

In a copy of this query substitute an actual invoice number and run it. Assuming you haven't disabled warnings, you should see how many records it will affect vs how many you think that it should. If it appears that it will work, your form field is likely not returning anything to the query. Maybe it's not being updated before the query runs. Maybe it's unbound, which will compound the non-update effect, in which case you probably need to retrieve the control Text property.

I think you have redundant data. If the paid date is null, there is no payment, yes? Then you don't need a check field for that.

[DMT Dave]

Thanks guys, will test the query by changing to a select query first to try and retrieve the records, the txtCriteria is also just a text box where the invoice number is held via the user prompt, in the table it is set to a number, will try a few things but first a select query, thank you all