Transfer data from form to another form

[FMKA]

1. I just gave you the syntax for referring to the main form item from the subform control.

2. You do not want to store that information as it is redundant and violates normalization rules, hence that is why I gave you the syntax I did which will DISPLAY the value from the main form but not store it in the subform.

Thanks a lot Bob

one more thing how can disable a Text box after Updating so that people cannot go there in and change data everytime they want i want to do that to avoid information Falsification

your help

[boblarson]

Thanks a lot Bob

one more thing how can disable a Text box after Updating so that people cannot go there in and change data everytime they want i want to do that to avoid information Falsification

your help

In the form's On Current event you can put:

Me.AllowEdits = Me.NewRecord

And, if you don't want deletions, change the form's AllowDeletions to NO in the form properties.

[FMKA]

In the form's On Current event you can put:

Me.AllowEdits = Me.NewRecord

And, if you don't want deletions, change the form's AllowDeletions to NO in the form properties.

Hi Bob

i have a question; in my calculation i do not want negative value for instance
5-12= -7 what kind of code can i use for not allowing negative value
appreciate your help