hi guys,i need some help,

[u]what i am trying to do :</u> its to ask the user to enter a date on the formula page, then press ok. and when the ok button is pressed, a request will be opened( to get the data and show it in a quiery).

Usually, i write the date in the criteria box for the specified field (on the request page)...

[u]but what i want</u> its to modify this date with the one the user will write when asked on the formula page.... maybe by using VB !?

if someone understood something from what i said, it would be great to help me fix this problem :)

mike

Is this a data access web page, or a form and report?

If a form and report, then in the query criteria, refer to the form control, like:

[Forms]![frmYourForm].[ctlFormControl]

Or pass it in where clause of the docmd, like

sLink = "[DateField] = " & "#" & dteDate & "#"

DoCmd.OpenQuery sQueryName, , sLink

Does this help?


mmcdonal

well its a a form and report

so in the query criteria, i have to refer to the form control u said,
[Forms]![frmYourForm].[ctlFormControl]
my form name is request data, but whats frmYourForm & ctlFormControl !?

the idea is to take the date on the form, like from text1 lets say, and insert it in the query criteria.

my boss is asking me to creat something on access, which is smethin never used in my life, i usually use c++

sorry for that man & thnx alot mmcdonal

mike

ok it worked thnx a lot dudeeee :):):)