Filtering a subform on a tab control from a separate form

[afreymor]

Hi all,

I am trying to filter a subform on a tab control based on an input on a second form.

Mainform: frm Index Page 2
Tab Control on Mainform: tabctrlMain
Subform: Customer Details
Tab Name: tabCustomerDetails

The second form is basically a separate Search Form where users can look for a customer ID and returns the ID back to Customer Details form.

So far I have managed to redirect focus to the correct tab on the tab control using the following code:

DoCmd.OpenForm "frm Index Page 2"
With Forms("frm Index Page 2")
!tabctrlMain.Value = !tabCustomerDetails.PageIndex
End With

However, I am stuck with the filtering part. Everything was working fine before I began putting the forms together into one big tab control (I tried using Navigation Pane but there were too many referencing problems so I gave up on that one).

If anyone could help me I would greatly appreciate it.

Thanks in advance!

 

[EternalMyrtle]

I used this as a guideline when I was having a similar issue: http://allenbrowne.com/ser-28.html

Basically, you need to temporarily change the record source while the form is filtering the subform records.

Hope this helps.

 

[afreymor]

Hi EternalMyrtle!

Thanks for your reply! I haven't tried it out yet, but this looks just the thing I might need. I'll try it when I have the chance this weekend.

Cheers!