Hey !
If people have read my previous post, this is my second question:
I'd like to achieve something using a Tab Control, but don't even know if that's possible.
Some background info:
I've got a mainform, let's call it frmCustomers with Record Source the
customers table tblCustomers (not the real names but to keep it simple).
This form has a subform frmsubOrders, which was based on the tblOrders table. The tblOrders table
has a field 'Current' (Yes/No) indicating which is the current order.
There's a PK relationship between CustomerID (tblCustomers) and fkCustomerID (tblOrders) )
What I'd like in the subform: a tab control with first tab = 'current orders' and second
tab = 'previous orders'. This means that for 1 customer in the main form, all orders with
Current = True would appear on the first Tab, and all orders with Current = False would
appear in the fields on the second Tab.
What I can think off is creating a tab control on the main form and put a Subform1 on the
first Tab with subform using Record Source = saved query 'select * from tblOrders where Current = True'
and on the second Tab another subform Subform2 using Record Source = saved query 'select *
from tblOrders where Current = False'.
But this is quiet static.
Does anybody knows if this can be done using 1 subform (with tab control) and programmatically
positioning the records on the right tab ?
Thanks for any suggestions !!!
Regards,
Evelyne
If people have read my previous post, this is my second question:
I'd like to achieve something using a Tab Control, but don't even know if that's possible.
Some background info:
I've got a mainform, let's call it frmCustomers with Record Source the
customers table tblCustomers (not the real names but to keep it simple).
This form has a subform frmsubOrders, which was based on the tblOrders table. The tblOrders table
has a field 'Current' (Yes/No) indicating which is the current order.
There's a PK relationship between CustomerID (tblCustomers) and fkCustomerID (tblOrders) )
What I'd like in the subform: a tab control with first tab = 'current orders' and second
tab = 'previous orders'. This means that for 1 customer in the main form, all orders with
Current = True would appear on the first Tab, and all orders with Current = False would
appear in the fields on the second Tab.
What I can think off is creating a tab control on the main form and put a Subform1 on the
first Tab with subform using Record Source = saved query 'select * from tblOrders where Current = True'
and on the second Tab another subform Subform2 using Record Source = saved query 'select *
from tblOrders where Current = False'.
But this is quiet static.
Does anybody knows if this can be done using 1 subform (with tab control) and programmatically
positioning the records on the right tab ?
Thanks for any suggestions !!!
Regards,
Evelyne