refer to every record on a datasheet

[ahmed_optom]

Hello,

So heres the problem.

we have a form and a subform. Subform is in datasheet view.

I want to be able to change a value on every record that appears in the datasheet filtered view.

Eg.

Im collecting all transactions for each individual.

So I list the transactions by user ID. This is fine so far.
I then total the transaction value, again so far so good.
Now when I create a pay option, I want to change the Status field on all of the transactions for that individual listed in the subform to "payed".

Any ideas?

 

[ahmed_optom]

Ok I solved my own problem.

Its really weird, I have been looking at this issue for a few days, and its always just after I get really fed up and post it on here that I solve the problem.

So what I did is create a query, use update query, and then get the ID from the form, and then update all the relevant records. I call the query when I complete the payment.