By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 2,157 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

display last update in a form box/field ?

P: n/a
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 -
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <no**********@nowhere.com> wrote in message
news:M6***************@news04.bloor.is.net.cable.r ogers.com...
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 -

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.