Re: Default form date same as last entry....

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Trevor (anonymous_at_discussions.microsoft.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 16:47:34 -0700

=[LastDate]![OrderDate]

LastDate is the name of the query and OrderDate is the
field returned by the query. The query returns only one
record, as it should. But it does not display this date
in the form.

Thanks,

Trevor

>-----Original Message-----
>What is the code you use to set the DefaultValue property?
>
>"Trevor" <anonymous@discussions.microsoft.com> wrote in
message
>news:1f2001c49a6f$70d8a4b0$a501280a@phx.gbl...
>> Hello All,
>>
>> I have a form which is used to enter invoice data. I
>> wanted to have the date field on the form default to
>> whatever date was used for the last entry. I set up a
>> query that finds the last record in the table and
returns
>> to me the date associated with that entry. The query
>> works fine and returns what I want when run on its own.
>> However, when I set the default value property of the
>> textbox on the form to the result of that query, the
form
>> field simply shows "#Name?". Any ideas as to what I am
>> doing wrong?
>>
>> Any help is much appreciated. Thanks.
>>
>> Trevor
>
>
>.
>

Relevant Pages