Set Value in Continuous Form

[Gigitty]

Hi guys.

I have a yes/no (checkbox) I want to set to 'No' each time the form loads. I've tried {me.fieldname = No} in the OnLoad event. This only works for the first record on teh form. Anyone know how I can apply this to every record on the form? VBA beginner here..

thankyou in advance.
Gigitty

 

[June7]

Can execute an UPDATE action SQL on the entire table or if the form is filtered apply same filter criteria in the UPDATE.
In the form Open or Load event:

CurrentDb.Execute "UPDATE tablename SET fieldname = False"

 

[Gigitty]

In the load event, the only record you would reference is the first one. What is the purpose of updating the records when you view them?

It's being used as part of a Inventory and Ordering System and I want to reset this yes/no box on each record every time I open this [New Order] form so the user then clicks the yes/no box for each item they wish to order.

 

[theDBguy]

It's being used as part of a Inventory and Ordering System and I want to reset this yes/no box on each record every time I open this [New Order] form so the user then clicks the yes/no box for each item they wish to order.

Is the table for this form in the backend?

 

[Gigitty]

Is the table for this form in the backend?

yes it is.

 

[theDBguy]

yes it is.

In that case, what would happen if another person is currently using that form when you open yours in your frontend? All their work will disappear, right?

 

[Gigitty]

In that case, what would happen if another person is currently using that form when you open yours in your frontend? All their work will disappear, right?

It's actually for an individual user (only 1 staff member), but I acknowledge your point. The idea is that as multiple items are ordered on each order, once the 'Add To Order' box is ticked and all items have been selected, the user then clicks the 'Save Order' button which does everything ni the background (see attached doc)

 

[Gigitty]

As an extra point of note, the end user wants to be able to see current 'Floor Stock', 'Base Stock' and 'Backorder' information (all of which is calculated in the background) for all stock items in the continuous form of which there are over 2500 which is why I've gone down this path. Couldn't think of an easier solution..

 

[Gigitty]

Many thanks Pat.