Help!
I am writing a snippet of VBA code for an MS Access database and I need to know how to 'back fill' data to a field. My field is called 'MoonPhase' and is filled AFTER a date has been entered into the Date field. Suppose, There are two fields in the database, First is named 'Date' and is comprised of a Date field. Once the Date is entered and <Enter> is pressed, the background process does the math on the date, finds the phase of the moon (per Date) and back fills the moonphase into the field. Can someone help me please. Thanks in advance. -Larry