Linking Two Main Forms

[Guirg]

Hey all,

I have 2 unrelated forms sitting on a form one above the other. I then have a range of search options on to search each form independantly. They share a common date field but theres no relationshi[ established between them...

What im trying to do it make it so when form1 is searched for a specific outcome form2 shows the dates corresponding to the results in form1 and visa versa....

been trying for a while to be able to do this and i keep ending up at dead ends.. any ideas would be wonderful!

Cheers

Tim

 

[Galaxiom]

It is reasonably easy to make one form track the other but to make them track each other would have to be done with vba code. With simple linkages they would chase each other in an endless loop.

How much experience do you have in vba?

Are you requiring a shared date range or a single shared date?

 

[Guirg]

im not the best with vba but what i cant figure out i generally google and find and expand to do what i need...

range but the range wont be continuous so a dates are essentially random if u look just at them... is there any way to extract the data in a column into a string???

 

[Galaxiom]

range but the range wont be continuous so a dates are essentially random if u look just at them... is there any way to extract the data in a column into a string???

So you would like to collect the individual dates from the records displayed in one form (presumably a Datasheet view) and display the records with matching dates from the record source of another subform (also in datasheet view). I assume there will be a button to indicate which is the current master subform and update the other subform.

Are the records selected entirely on the date values in the other form or are there other controls and filters involved with each subform?

Rather than trying to extract a string from data in one form to use in the other's record source I would be inclined make one subform's record source query based on the record source query of the other subform. Reversing the connection will require dynamic record source queries set in vba.