showing only relevant information due to active textbox

[Damien Ramsey]

hello there

Info: I have a form on which is displayed information, customer code,
address and balance etc..
on that form i also have start of the current week, which is
displaying 29th march 2004 today for instance. this text box is
active, what i mean is when i press the plus or minus keys this text
box moves up and down one week.
now i also have on this form a subform of sales, which is a customers
weekly orders, this displays product code, mon, tue, wed, thur, fri,
sat, sun.

The problem: what i want to do is diplay the relevant information due
to the week start.
you see, a customer can change their order permanently, but i still
need to keep a record of it to display,
for example:
in my sales table for customer A100
Code StartDate
FCP 01/05/1999
FCP 15/03/2004
SSP 19/04/2004

so above you can see that this customers weekly order has changed for
FCP to take effect on 15/03/2004.

so what i want to do is display only the information which is relevant
to the weekly start date, i.e. this week for customer A100 I only want
to display the records of
FCP 15/03/2004
SSP 19/04/2004
and when i move through the weeks it will show only the relevant
information.

if anyone has any ideas please let me know, anything would be a great
help

[Matthew Sullivan]

I'm not quite following the schema on your subform (the "mon, tue,
wed,..." stuff). But, presumably you've got a Sales Date somewhere
in there. If so:

Make the subform's Record Source a query that uses the date from the
parent form as a criterion for your Sales Date.

You can refer to the parent form text box like this (air code):
Forms![ParentFormName]![NameTextBoxWithDate]

So, the datasource for your subform would look something like this
(assuming the parent form is named frm_Sales and the text box is named
txt_CurrentDate):

SELECT tbl_Sales.*
FROM tbl_Sales
WHERE (((tbl_Sales.SalesDate) Between
[Forms]![frm_Sales]![txt_CurrentDate] And
([Forms]![frm_Sales]![txt_CurrentDate]+7)));

-Matt

On 1 Apr 2004 02:53:54 -0800, ra**********@hotmail.com (Damien Ramsey)
wrote:

hello there

Info: I have a form on which is displayed information, customer code,
address and balance etc..
on that form i also have start of the current week, which is
displaying 29th march 2004 today for instance. this text box is
active, what i mean is when i press the plus or minus keys this text
box moves up and down one week.
now i also have on this form a subform of sales, which is a customers
weekly orders, this displays product code, mon, tue, wed, thur, fri,
sat, sun.

The problem: what i want to do is diplay the relevant information due
to the week start.
you see, a customer can change their order permanently, but i still
need to keep a record of it to display,
for example:
in my sales table for customer A100
Code StartDate
FCP 01/05/1999
FCP 15/03/2004
SSP 19/04/2004

so above you can see that this customers weekly order has changed for
FCP to take effect on 15/03/2004.

so what i want to do is display only the information which is relevant
to the weekly start date, i.e. this week for customer A100 I only want
to display the records of
FCP 15/03/2004
SSP 19/04/2004
and when i move through the weeks it will show only the relevant
information.

if anyone has any ideas please let me know, anything would be a great
help