Default Value

[Jeni]

I have table called PlanMonth and field called Generation.
For month of Nov to April i want to put the default value to 150. For month
of May to October I want to put the default value to 115. I donot know how
can i put this logic. Can anyone help?

Thanks
Jeni

 

[Alex Dybenko]

Hi,
normally you set default in a form, where records are entered. Check the
month in form's load event and set appropriate value to
Me.Generation.DefaultValue

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Jeff Boyce]

Jeni

Will these values ALWAYS be associated with these months? If so, consider
NOT putting the values in your table ... after all, knowing the month will
mean the value has already been determined, right?

Instead, use a query and an IIF() statement to dynamically "calculate" these
values in the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP