Refreshing Single Control

[Chuck]

I have a form that contains bounded text boxes where I input data. Three
other boxes include a time stamp, the windows logon name and a list box that
queries a table of employee name. The list box is a multi-select which I
use to capture names that work on a project. The time stamp and user name
is captured at the save of the record. The list box is an unbound box that
takes its data from a table of names. Once selected and saved, the names
are stored and used for reporting purposes. At any time, the record can be
updated. I am using code found in the newsgroups that retrieve the names
and highlights the correct ones in the list box when the record is viewed.
If I make a change to the list box and save the record, the highlights
disappear becauase I use a refresh on the form to update the date and time
stamp and user name. Can I just refresh the time stamp instead of the whole
form. I've tested the form without the refresh and the names stay
highlighted. Make sense?

 

[smk23]

If I understand you, you are trying to update a field you call "time stamp"
independent of other activities on the form.

Rather than refresh the form, just execute this:

[Time stamp] = Now()

when you want to update this field, assuming "time stamp" is the name of the
field. Whatever triggers the refresh could run this code instead.

 

[Chuck]

Thanks, but I do that already. I guess maybe it was confusing. I have a
SAVE button that checks all the fields to ensure its accuracy and the SAVE
button updates the time stamp. Its in the list box that contains the
employees names that I would like to stay highlighted after the save is
complete. Instead, it updates the record and the highlighted names become
un-highlighted. I would like to keep them highlighted. A few people
complained about it thinking they missed something.

If I understand you, you are trying to update a field you call "time
stamp"
independent of other activities on the form.

Rather than refresh the form, just execute this:

[Time stamp] = Now()

when you want to update this field, assuming "time stamp" is the name of
the
field. Whatever triggers the refresh could run this code instead.
--
sam

I have a form that contains bounded text boxes where I input data. Three
other boxes include a time stamp, the windows logon name and a list box
that
queries a table of employee name. The list box is a multi-select which I
use to capture names that work on a project. The time stamp and user
name
is captured at the save of the record. The list box is an unbound box
that
takes its data from a table of names. Once selected and saved, the names
are stored and used for reporting purposes. At any time, the record can
be
updated. I am using code found in the newsgroups that retrieve the names
and highlights the correct ones in the list box when the record is
viewed.
If I make a change to the list box and save the record, the highlights
disappear becauase I use a refresh on the form to update the date and
time
stamp and user name. Can I just refresh the time stamp instead of the
whole
form. I've tested the form without the refresh and the names stay
highlighted. Make sense?

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George

 

[eos]

AUTO-REPLY From George Levitt

Please allow this to confirm a system receipt of your e-mail.

I am out of the office until Wednesday morning (1/12/05) and will not be
reviewing or responding to email or voicemail until that time.

I look forward to replying to your message on Wednesday.

Thanks and warmest regards, George