Back Fill Access Field, Date->MoonPhase... Help!

[LarryE]

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

[pbaldy]

I'd probably use the after update event of the date textbox. I'd have a function that accepted a date, did the math, and returned the phase. I have no idea what the math is.

[LarryE]

I'd probably use the after update event of the date textbox. I'd have a function that accepted a date, did the math, and returned the phase. I have no idea what the math is.

Problem I need solved is... how do I take the data from my function MoonPhase() and place it into MoonDate (Field)?

[pbaldy]

Me.MoonDate = FunctionName(Me.DateFieldName)

[pbaldy]

This may help:

http://www.baldyweb.com/Function.htm