Updating Tabel from Form

[Haz]

I have a form that is created based on a table. Three fields on the table are:

date
Type
Recd
Used

I added another 6 text boxes sub_type1,2,3 and Used1,2,3 into the form. These added boxes have iif statments and forumlas which display a value. I need the value of the sub_type to be stored on the origonal table fields. The fields type are the same. sub_type1,2,3 should be stored in Type and used1,2,3 in Used hitting the add button.

Apperciated any help.

 

[pbaldy]

http://allenbrowne.com/casu-14.html

 

[Haz]

The link above to store calculated results in new field. But my question how to store results or values of the new fields into existing fields?

 

[Atomic Shrimp]

If you can calculate the values, why bother storing them at all?

 

[Haz]

They have to be stored for records and reports purposes.

Here is a picture of the form and fields

 

[Atomic Shrimp]

The example given by pbaldy is actually exactly what you need.

 

[pbaldy]

The link shows how to store a calculated value in any field, but also includes a caution against saving them at all. Here's another that's more on-point for inventory:

http://allenbrowne.com/AppInventory.html

 

[Haz]

I think I either didnt explain my problem well or it's more complicated. I have attached of samiliar database to look at.

How can i have text4,text6,text8,text9 stored into pinven table

text4 and text8 into ptype field
text6 and text9 into used field

 

[pbaldy]

As detailed in the link:

Me.Used = Me.Text6 + Me.Text9

in the appropriate event.

 

[Haz]

The resulted value is not stored as new records . Text4 and text 6 should be stored as new record in the table. The above forumla replaced current ptype used qty. See picture.