Kayleigh
Member
- Local time
- Today, 14:38
- Joined
- Sep 24, 2020
- Messages
- 706
Okay can't believe I'm already posting another query! This time I really did try to find the answer before posting it here...
So I have a pop-out unbound form which contains a bound continuous subform based on tblStudents. Here is where it gets tricky...
When user has selected which records they would like, this is committed to another table.
Now I would like to filter the form so it only shows records relevant to the previous form (frmSession), so this can be done through query or possibly the join table. However when I try adding filter to the argument of OpenForm cmd in VBA it runs into error stating it can't filter an unbound form.
So what is best way to apply filter?
So I have a pop-out unbound form which contains a bound continuous subform based on tblStudents. Here is where it gets tricky...
When user has selected which records they would like, this is committed to another table.
Now I would like to filter the form so it only shows records relevant to the previous form (frmSession), so this can be done through query or possibly the join table. However when I try adding filter to the argument of OpenForm cmd in VBA it runs into error stating it can't filter an unbound form.
So what is best way to apply filter?