So I have a list in combo box - A.M., P.M. or LUNCH
If the user chooses A.M. then I would like it to save it to tblTest column called AM
If the user chooses P.M. from the combo list then I would like it to save it to tblTest column called PM
Is it possible to create something like this? maybe create expression in control source? but does anyone knows the code ?
or maybe SQL Statement will work?
PLEASE HELP!
thanks!