If you already have a form setup to accept the date, you may use the after
update event to set the calculated date using this code:
me.<your calced date's text box name> = dateadd("m", 3, me.<your input date
text box name>
You can make the calculated date's text box invisible if the user doesn't need
to see it.
-------------- Original message --------------
From: Dennis Jensen <[EMAIL PROTECTED]>
> No?... This gets you the data. What you do with it
> after that is entirely up to you. As a suggestion you
> could simply make an SQL Query to do the update or I
> am sure that there is some intergrated way to do it
> with Access directly but being a VB programmer I tend
> not to use those methods someone else will have to
> help you that. As for information on how to do a SQL
> statement just look it up they have examples for those
> use the keywords UPDATE SQL that should get you what
> you need.
>
> --- mudrobin wrote:
> > In either case, by using this code, it should
> > take the result and store it in the table in
> > the field I need it to? Also, under what sub
> > do I put the code (ie AfterUpdate for the field
> > where I manually put in the date?)
> >
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessVBACentral/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
