Copy field data from form to subform

[KEKeogh]

I’m pretty sure this possible but I’m just not finding a code that works. Here’s what I am trying to do:

I have a form puling from one table and then a subform in that form pulling from another table.

I have a field in the [FORM] called [GROSS REFUND] and a field in the [SUBFORM] also called [GROSS REFUND]



I want the value of [FORM].[GROSS REFUND], if the value is not zero, to be copied into a new record on the [SUBFORM.[GROSS REFUND]



I’m thinking this can be done with some kind of code as an After Update Event.

Does this makes sense? Is it possible?

Thanks
Kathie

 

[Cronk]

Why do you want to store the same data in 2 places. It goes against principles of good database design.

It seems to me, you are wanting to store a running balance in the sub form records. What happens if the records are entered out of order or an edit subsequently takes place. Can of worms (or worse) IMO.

If you want a running balance, use a calculated field.

 

[KEKeogh]

I'm actually trying to combine 2 spreadsheets that this company uses and create a database with the least impact possible. For now I want to keep the spreadsheets as seperate tables, making the transfer of the data as error free as possible.

Not trying to keep a running total but more keeping track of the check amounts we will be receiving and then marking whether they are received or not.

No calculations are needed.

 

[Cronk]

Kathie

You need to supply more information about the tables and the key fields. Better is a copy of your database with sample data. Are the spreadsheets linked or imported?

However to answer your original question about whether it is possible, it will be if the data structure is logical.