Hello all,
Though I'm programming for some years now, I'm a COMPLETE Access/VBA newbie...
I'd like to find some answers that can clear my head a bit as this is driving me mad !
I'm using Access2000 and I've been reading 2 massive books about VBA and Access Programming
and still don't manage. I keep seeing stuff about DAO and ADO and just don't know what to
use anymore. I'm at the point that I'm feeling STUPID !
In fact, I've got two questions but will post them separately. So here's the first bit:
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 (for me...) ).
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.
As I didn't want to show all orders for a customer (PK link between CustomerID (tblCustomers)
and fkCustomerID (tblOrders) ) but only those with a 'current' flag set to True, I tried
everything I could with filter on the subform. I read previous posts about how to refer to
the subform like Me!frmsubOrders.Filter = blabla or Me!frmsubOrders.Form!Filter = blabla but
just don't manage with this. Keep having error messages that say that or this method is not
used or that it doesn't find frmsubOrders etc... I've put this pieces of code in the
On Load event of the main form...
The only thing that finally worked is using as Record Source a saved query which selects
* from tblOrders where Current = True.
But I'd like to know if there's a way to do it with the filter stuff as this makes it more
dynamic and how exactly I have to refer to subforms and methods of it (and where I have to put
the code).
Sorry if you feel that this has been asked before, but I've been through all the previous posts
and have tried everything I read and.... :-( Must be me...
If somebody can help me out, thanks sooo much !
Regards
Evelyne
Though I'm programming for some years now, I'm a COMPLETE Access/VBA newbie...
I'd like to find some answers that can clear my head a bit as this is driving me mad !
I'm using Access2000 and I've been reading 2 massive books about VBA and Access Programming
and still don't manage. I keep seeing stuff about DAO and ADO and just don't know what to
use anymore. I'm at the point that I'm feeling STUPID !
In fact, I've got two questions but will post them separately. So here's the first bit:
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 (for me...) ).
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.
As I didn't want to show all orders for a customer (PK link between CustomerID (tblCustomers)
and fkCustomerID (tblOrders) ) but only those with a 'current' flag set to True, I tried
everything I could with filter on the subform. I read previous posts about how to refer to
the subform like Me!frmsubOrders.Filter = blabla or Me!frmsubOrders.Form!Filter = blabla but
just don't manage with this. Keep having error messages that say that or this method is not
used or that it doesn't find frmsubOrders etc... I've put this pieces of code in the
On Load event of the main form...
The only thing that finally worked is using as Record Source a saved query which selects
* from tblOrders where Current = True.
But I'd like to know if there's a way to do it with the filter stuff as this makes it more
dynamic and how exactly I have to refer to subforms and methods of it (and where I have to put
the code).
Sorry if you feel that this has been asked before, but I've been through all the previous posts
and have tried everything I read and.... :-( Must be me...
If somebody can help me out, thanks sooo much !
Regards
Evelyne
