Hi - I have what should be a simple question for someone to answer. I'm creating an access database and will have 2 fields. The first will allow the user to enter a date. The second will show this date + 14 days ahead. So, if i enter 5/3/03 in field name [Date], field name [Date14] should show 5/17/03.
Initially, I thought I should modify the default value box. However, when i do that, I keep getting an error saying that access doesn't recognize that field name or default value.
I then tried putting [date14]=[date]+14 in the [date] afterupdate property, but when i did, i received the following error when i tried out the form:
"Microsft Access can't find the macro '[Date14]=[Date]+14' The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note that when you enter the macrogroupname.macroname syntax in an argument, you must specify the name the macro's macro group was last saved under."
What's the best way to do this? Do I need to create this as a macro somehow? Thanks for the help.
Lee
Initially, I thought I should modify the default value box. However, when i do that, I keep getting an error saying that access doesn't recognize that field name or default value.
I then tried putting [date14]=[date]+14 in the [date] afterupdate property, but when i did, i received the following error when i tried out the form:
"Microsft Access can't find the macro '[Date14]=[Date]+14' The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note that when you enter the macrogroupname.macroname syntax in an argument, you must specify the name the macro's macro group was last saved under."
What's the best way to do this? Do I need to create this as a macro somehow? Thanks for the help.
Lee