Exchange Data between two subforms

C

CP

I have a form containing two subforms lets say MainForm, Subform1, Subform2
They have the following fields
Mainform - MainID, Info1, Info2
Subform1 - SubID, MainID, Info3, Date1
Subform2 - ID, SubID, Info, Date2

So they have links where needed

What I want to do is when updating Date2 is to change Date1 by Date2
+12months giving a yes and no confirmation box first.
So I first have to do the calcualation then put the new value in another
subform field and ask the question

Like - Are you sure you want to change Date1 to xx/xx/xxxx ? yes or no.

Many thanks for any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Synchronizing subforms 0
Form with two subforms 1
linking two subforms 2
Passing criteria between subforms 4
Adding records relating to intervals between two dates 4
Linking two datasheet subforms 1
Odd behaviour after tabbing between subforms 1
Synchronization problem openform bookmark 1

Top