Subform based in a query criteria is blank at the time to load, ho

[ldiaz]

I have a form where I have two fields named:
[StartDate] and [EndDate]

and I have a subform where it's connected to a query with this criteria.
Between ([Forms]![frm_Shipment_SystemAllDatas]![StartDate]) And
([Forms]![frm_Shipment_SystemAllDatas]![EndDate])

it works OK, but at the time to load the form the subform is completely
blank, how can I chage this? I want it shows all datas that are on the query,
and filter after to put data range and make the requery

Thanks
LD

 

[NetworkTrade]

I think it is blank because there is no data - - if it first loads there are
no values in the date fields on the form....so there is no records in the
query and therefore the subform is blank......

If the blank form is an issue, You need to manage the
presentation....perhaps have the subform not visible until there is some
dates and then with a button or something make visible with a requery....

 

[ldiaz]

Yes I have values, but the are not showed in the subform, I think I need to
use:
Like Nz => (([Forms]![frm_Shipment_SystemAllDatas]![StartDate]) And
=< ([Forms]![frm_Shipment_SystemAllDatas]![EndDate]),"*)

I have tried this code but it does not work..

do you know how this code needs to be written?


Thanks
LD





--
Lorenzo Díaz
Cad Technician

I think it is blank because there is no data - - if it first loads there are
no values in the date fields on the form....so there is no records in the
query and therefore the subform is blank......

If the blank form is an issue, You need to manage the
presentation....perhaps have the subform not visible until there is some
dates and then with a button or something make visible with a requery....
--
NTC

I have a form where I have two fields named:
[StartDate] and [EndDate]

and I have a subform where it's connected to a query with this criteria.
Between ([Forms]![frm_Shipment_SystemAllDatas]![StartDate]) And
([Forms]![frm_Shipment_SystemAllDatas]![EndDate])

it works OK, but at the time to load the form the subform is completely
blank, how can I chage this? I want it shows all datas that are on the query,
and filter after to put data range and make the requery

Thanks
LD

 

[ldiaz]

I have corrected my code;
Like Nz((>=[Forms]![frm_Shipment_SystemAllDatas]![StartDate]) And
(<=[Forms]![frm_Shipment_SystemAllDatas]![EndDate]),"*")
and now it's working fine.


Thank you so much any way
LD

--
Lorenzo Díaz
Cad Technician

Yes I have values, but the are not showed in the subform, I think I need to
use:
Like Nz => (([Forms]![frm_Shipment_SystemAllDatas]![StartDate]) And
=< ([Forms]![frm_Shipment_SystemAllDatas]![EndDate]),"*)

I have tried this code but it does not work..

do you know how this code needs to be written?


Thanks
LD





--
Lorenzo Díaz
Cad Technician

I think it is blank because there is no data - - if it first loads there are
no values in the date fields on the form....so there is no records in the
query and therefore the subform is blank......

If the blank form is an issue, You need to manage the
presentation....perhaps have the subform not visible until there is some
dates and then with a button or something make visible with a requery....
--
NTC

I have a form where I have two fields named:
[StartDate] and [EndDate]

and I have a subform where it's connected to a query with this criteria.
Between ([Forms]![frm_Shipment_SystemAllDatas]![StartDate]) And
([Forms]![frm_Shipment_SystemAllDatas]![EndDate])

it works OK, but at the time to load the form the subform is completely
blank, how can I chage this? I want it shows all datas that are on the query,
and filter after to put data range and make the requery

Thanks
LD