I have a sub form (m_p_sub) in access that has a combo (combo_1) that gives different info depending on what selection you choose in the first combo (visit_class)
When i was making the form i used a query in the row source of combo_1 such as:
WHERE vtype = Forms!m_p_sub!visit_class;
When i dropped it in to the other form (chart_review) which is in a tab of ANOTHER form (chart_review_main) obviously, it doesn't work.
I'm pretty new to sql/vb/access but i tried a couple of things like:
but no joy....
Can anyone help (i'm sure i deserve a good eye rolling for this but, hey i'm learning )
Thanks in advance