Default value depending on another field

[lunarmono]

Hi there,
I am interested in making one field of a table depend on another field. Specifically, I have a date in one field, and would like another field to automatically contain this date's day of week. So if you type in the date, for example, "8/1/2003", the day of week field would automatically contain "Friday". Is this possible? Thank you kindly...
-Andy

 

[hymn]

MyDate = Date taken from a field called Date_From and displays the Day

try the code below but change the field names to siut your fields

MyDate = Me!Date_From
Me!MyDay = Format(MyDate, "dddd, &quot

Hope this helps
Hymn

 

[lunarmono]

I apologize but I am very green at this. Where exactly would I type this code in so that it would affect this change?
Thanks,
Andy

 

[hymn]

in the On Enter event of the field that you want the DayofTheWeek in

Hope this helps
Hymn

 

[lunarmono]

I know how to find the on enter for boxes in form design but in datasheet design I cannot locate any on enter
I tried the code, and just the "Format()" part in the Default Value box for my day of week but that didn't work. Thanks for the help
Andy

ps I also realized that if I put it in long date format, then access automatically calculates the day of the week and includes that with the date. This might work for my purposes

 

[hymn]

Go to design view of your datasheet form go to the field that you want the day to be in rightclick on that field go into properties click the tab for Event go down about six events and there is one called On Enter on the little button with 3 dots click on that high code builder click OK and then place the code in there
Remember you have to enter the field before any thing will happen

Hope this helps
Hymn

 

[lunarmono]

Thanks, worked like a charm!