Date as an Expression That is editable

[ldXbl]

I need to add an expression to a query that would allow the user to input a date on the form. right now all i have is "InputDateate()" that just gives me a non editable date field with todays date. I have tried other ways but the expression becomes either a binary or text filed and cant be linked to my date in the subform. Thanks in advance for all the help..

 

[scriverb]

Give this code a try:

InputDate:  IIF(IsNull([Enter Date:]), Date(), [Enter Date:])

I think should work for you. This will prompt for the Date. If the user doesn't enter anything then Date() is used. If he enters a date then that entry is used.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]

 

[ldXbl]

Thanks for your quick responce. What you suggest would not work as i needed. because i need the user to be able to enter the date on the form and change the date to update the subform. you can see an example of the form at

http://www.dbxtreme.com/example.gif

the field circled needs to be editable so that when the user updates the field it changes the data in the subform. if i can make the field in the query i can link it to the date filed in the bottom subform and it will update as needed.

Thanks for your help

 

[ldXbl]

Thanks guys I solved the problem....I just needed to dig a little more in this big open space between my ears...