display last update in a form box/field ?

[BLUE WATER]

Does anyone know how I can see a value in my form field text box ?

I tried to add a text box, but the record source doesn't list the variable
I want to see for each record. The variable is the Last Updated Date
for that given record.

How do I get it to show ?

I also tried

= [form name]![variable last update]

but this produced an error.

Thanks -

[Larry Linson]

Re: display last update in a form box/field ?

Do you have a DateLastUpdated field in the Record? Do you maintain it by
setting it in the Before Update event of the Form(s) from which the Record
may be updated, and force all updates to be done via the Forms?

If so, then it would appear you are using a Query or SQL statement for the
RecordSource, and have not included that Field. Check your Record Source and
include the Field.

Larry Linson
Microsoft Access MVP

"BLUE WATER" <notavailable@n owhere.com> wrote in message
news:M6Yec.693$ le3.474@news04. bloor.is.net.ca ble.rogers.com. ..[color=blue]
> Does anyone know how I can see a value in my form field text box ?
>
> I tried to add a text box, but the record source doesn't list the variable
> I want to see for each record. The variable is the Last Updated Date
> for that given record.
>
> How do I get it to show ?
>
> I also tried
>
> = [form name]![variable last update]
>
> but this produced an error.
>
> Thanks -
>
>[/color]