Testing for Date Value then Displaying the Date or Text

Hi,

I have a form that currently displays the date of a visit.

Currently the user can only input a date.

I would like to be able to show the text control as a Date OR a value of
'Missed Visit'. The user needs to be able to enter a Date or 'Missed
Visit'.

If the date is entered then the field 'Visit Date' is updated, if 'Missed
Visit' is entered then 'Visit Status' is updated to 'Missed Visit'

I was trying to write a function that looked up the Visit Date, checked the
Visit Status and displayed either one, and a function that would properly
update the fields, but I am hopeless and a novice - any advice?

Deborah


.

Relevant Pages

  • Re: Apologies
    ... inappropriate for novices to give advice, however, just for people to ... it is lovely to watch someone harmoniously floating around the menage and 'in tune' with their horse. ... But, lets just say that people do not get there completely without help, even if what you consider 'novice' might differ to what I consider to be novice. ... It is good to read books, but from my life experience, sometimes to just need to bounce ideas around with people and see what you come up with together. ...
    (uk.rec.equestrian)
  • sycamore saplings!
    ... being a complete novice I thought it might be wise to get some advice! ... my hands and knees pulling the little blighters up? ... Any advice would be ...
    (uk.rec.gardening)
  • Re: jeep endurace mods
    ... > Just a novice looking for some advice and a place to start in the world ... > of jeep modification... ... > improve the stock parts on it in order to promote a good, healthy, long ...
    (rec.autos.4x4)
  • Re: Regarding Storage Virtualization
    ... can anyone enlighten me about out of band storage virtualization! ... i am novice in field of SAN kindly advice me a good resource!! ...
    (comp.arch.storage)
  • computer question
    ... device manager. ... any advice? ... John ... Prev by Date: ...
    (rec.music.phish)