removing data from a table

[bmoyer123]

When shipping products in my DB, I use a form. If I ship large number of records at one time, I would like to change the status of these items to Shipped and to remove the products from specific storage location. How can I do this using the form. I could do after update, but I cant seem to get it to do what I want. Don't know if I'm explaining this correctly.

Example:
Product Bag id shipped storage status
W1 A0 V6 Q
W1 B0 V6 Q
W1 C0 01/26/17 S
W1 D0 01/26/17 S

I could have 20 some bags to ship, and would need to key through each field to modify it with ship date, clear storage, and change status. Is there an easier way to do this than keying through each individual record/field?

[HansV]

How can we distinguish the records whose status has to be changed from other records?

[bmoyer123]

There will be an entry in shipping filed with current date. I don't see how to avoid entering this data for all records shipped. It used to be we would ship entire collection #, but now that will not be true. We may only ship some bags and not all.

[HansV]

If you have to enter the date, you might as well update the status in the After Update event of the control bound to the date field.

[bmoyer123]

Yes, but somehow I can't seem to get it to work. What ACTION should use in a Macro?

[HansV]

I almost never use macros, but I suppose it should be the SetValue action.

[bmoyer123]

In the past that is what I used, but this is no longer an option in the drop down menu.

[HansV]

You must click to highlight the "Show All Actions" button. This button is only enabled if the database is stored in a trusted location for Access or if it is a trusted document.

S1473.png

The SetValue action should then be available:

S1474.png

[bmoyer123]

OK thank you.