Hi folks,
I have a form and use code to filter the records with varius drop down lists, for example, a name drop down list to filter records with only that name. At the end of the code I just use docmd.Applyfilter, strwhere
I want to use two dates to filter the records. I've only ever done this when it has been one date within the table, and I would use from and to txtboxes for that one date.
I've never done it so that the txtFrom relates to the "from" date in the table and the txtTo date relates to the "To" date in the table.
I've no idea how i'd do this. I mean, once I put the code down for the txtFrom "From", the code for the "To" date would have to take into consideration that it would have to start at the "From" date and not the beginning of time, if that makes sense!?
does anyone know how to do this or have spare code lying about that'll do the job?
Thanks for all help
I have a form and use code to filter the records with varius drop down lists, for example, a name drop down list to filter records with only that name. At the end of the code I just use docmd.Applyfilter, strwhere
I want to use two dates to filter the records. I've only ever done this when it has been one date within the table, and I would use from and to txtboxes for that one date.
I've never done it so that the txtFrom relates to the "from" date in the table and the txtTo date relates to the "To" date in the table.
I've no idea how i'd do this. I mean, once I put the code down for the txtFrom "From", the code for the "To" date would have to take into consideration that it would have to start at the "From" date and not the beginning of time, if that makes sense!?
does anyone know how to do this or have spare code lying about that'll do the job?
Thanks for all help
