How to show last visit date on a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a client visit form which allows me to pick the client's name from a
drop-down list but then I want the form to automatically show the date of the
previous visit (stored in a Sessions Table which is linked to the Clients
Table). How do I do this?
 
Barb,
Add a field to hold the date value for ex. [DOLV] (Date Of Last Visit)
Use the OnCurrent event for the form...
DOLV = Now
hth
Al Camp
 
Al,

What is the advantage of "OnCurrent" compared to "BeforeUpdate"

Robin


Barb,
Add a field to hold the date value for ex. [DOLV] (Date Of Last Visit)
Use the OnCurrent event for the form...
DOLV = Now
hth
Al Camp

Barb Poley said:
I have a client visit form which allows me to pick the client's name from a
drop-down list but then I want the form to automatically show the date of
the
previous visit (stored in a Sessions Table which is linked to the Clients
Table). How do I do this?
Click to expand...
Click to expand...
 
Robin,
The OnCurrent always "fires" whenever the form is "visited".
BeforeUpdate occurs only if a field in a previous record is edited.
Barb asked for...
I want the form to automatically show the date of the previous visit.
Click to expand...

The BeforeUpdate could be used in the same way to do a "Date of Last
Edit"

hth
Al Camp

Robin Chapple said:
Al,

What is the advantage of "OnCurrent" compared to "BeforeUpdate"

Robin


Barb,
Add a field to hold the date value for ex. [DOLV] (Date Of Last Visit)
Use the OnCurrent event for the form...
DOLV = Now
hth
Al Camp

Barb Poley said:
I have a client visit form which allows me to pick the client's name from
a
drop-down list but then I want the form to automatically show the date
of
the
previous visit (stored in a Sessions Table which is linked to the
Clients
Table). How do I do this?
Click to expand...
Click to expand...
Click to expand...
 
Thanks, that will be most useful.

Cheers,

Robin

Robin,
The OnCurrent always "fires" whenever the form is "visited".
BeforeUpdate occurs only if a field in a previous record is edited.
Barb asked for...
I want the form to automatically show the date of the previous visit.
Click to expand...

The BeforeUpdate could be used in the same way to do a "Date of Last
Edit"

hth
Al Camp

Robin Chapple said:
Al,

What is the advantage of "OnCurrent" compared to "BeforeUpdate"

Robin


Barb,
Add a field to hold the date value for ex. [DOLV] (Date Of Last Visit)
Use the OnCurrent event for the form...
DOLV = Now
hth
Al Camp

I have a client visit form which allows me to pick the client's name from
a
drop-down list but then I want the form to automatically show the date
of
the
previous visit (stored in a Sessions Table which is linked to the
Clients
Table). How do I do this?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top