Text Box Control Source???

[ccflyer]

Hi everyone,

This is a very simple problem, and it seems to me like it should work but it doesn't. On my form, I have a field called [mindate], which looks up the earliest date from a table. I also have a field called [maxdate] which looks up the latest date in my table. These both work great. My third text box [difference] is supposed to find the difference between the two above dates in days, but it doesn't work. The control source of this [difference] text box is this:

=DateDiff('d',[mindate],[maxdate])

Any suggestions?
Chris

 

[Liv Manto]

Hi everyone,
On my form, I have a field called [mindate], which looks up the earliest date from a table. this:

=DateDiff('d',[mindate],[maxdate])

Any suggestions?
Chris

Try using the name of your textbox

like me.textbox1.value

 

[ccflyer]

OK, I tried this, but still no luck.

=DateDiff('d',[me.mindate.value],[me.maxdate.value])

Thanks,
Chris

 

[Liv Manto]

Hi everyone,

I have a field called [mindate], which looks up the earliest date from a table. I also have a field called [maxdate] which looks up the latest date in my table. Chris

Do you mean mindate is a result of a query that looks for the earliest date?

 

[ccflyer]

Wow!!!! I deleted the current control source, and re-typed it and it magically works I have no idea why it works now, but it does. To answer your question, this text box looks at the [mindate] and [maxdate] text boxes which look up the lowest and highest dates from a table.

Thanks for the help,
-Chris