> Jeanetta,
> there are two fields in the table called "AGA_ROD and AWSA_ROD" there are
> only one value in each... is this ok?
>
> PR
>
> "Jeanette Cunningham" wrote:
>
>> Hi PR,
>>
>> If you are asking how to set a default date for a date text box when the
>> form opens, you can do it like this.
>>
>> In the load event of the form:
>>
>> Me.[NameOfDateControl].DefaultValue = "#" & DLookup("{AGA_ROD]",
>> 'tbl_ROD")
>> & "#"
>>
>>
>> When the form opens, the date in the text box will be the value of the
>> date
>> in field AGA_ROD in the table.
>> Note I am assuming that tbl_ROD has only one record, and that there is
>> only
>> one possible value for AGA_ROD.
>>
>>
>> Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
>>
>>
>> "PR" <PR[ at ]discussions.microsoft.com> wrote in message
>> news:8EA0AF95-7972-480E-B736-B90B3EE1A531[ at ]microsoft.com...
>> >I am trying to set up a routine that allows me to set dates when a form
>> >is
>> > open up...
>> >
>> > I have a table called tbl_ROD, which has 2 fileds held in it AGA_ROD
>> > and
>> > AWSA_ROD, what I would like to do is set this date on the form when
>> > update
>> > to
>> > one of these dates...
>> >
>> > Can anyone help me...
>>
>>
>>