Display Time based on another field value

[Shaun]

Im trying to insert the current time in a field based on another fields value
which has 3 different values from a list box the value in this field is text.
How do I go about write the formula?
SFCNS

 

[Jeff Boyce]

Shaun

Are you working in MS Access, the relational database?

Are you trying to do this in a form (good) or directly in a table (bad)?

Are you saying the "other" field has multiple values or just one?

More info, please...

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Doris Cobb]

Im trying to insert the current time in a field based on another fields
value
which has 3 different values from a list box the value in this field is
text.
How do I go about write the formula?
SFCNS