Change the value of a subform in form.

  • Thread starter Thread starter Ultraviolet47
  • Start date Start date
U

Ultraviolet47

Hello

I am creating a membership database.

I have a form called Frm_Exp30days based on the exp30days table with
name and addresses of who will expire in the next 30 days. In this
form, I have a subform called subfrm_dateexpire, which just has the
date expire field from another table. There's a button to extend
sponsorship by one year in this subform (and therefore the table). I
was looking for a command like DateAdd("yyyy", 1, Me.[Date Expire])

but I cannot get Access to recognise the table or subform and add on
the year, does anyone have any ideas of code that would work please? I
am using Access 2003.

Thank you
 
Hello

I am creating a membership database.

I have a form called Frm_Exp30days based on the exp30days table with
name and addresses of who will expire in the next 30 days. In this
form, I have a subform called subfrm_dateexpire, which just has the
date expire field from another table. There's a button to extend
sponsorship by one year in this subform (and therefore the table). I
was looking for a command like DateAdd("yyyy", 1, Me.[Date Expire])

but I cannot get Access to recognise the table or subform and add on
the year, does anyone have any ideas of code that would work please? I
am using Access 2003.

Thank you
Click to expand...

I would suggest that this table simply SHOULD NOT EXIST!

Its contents would change from day to day, and they'd be redundant in
any case. Can't you just put the expiry date - or, even better, the
membership start date and the term in months - into the Member table?
You could then use a Query to select which members are coming up for
renewal.

John W. Vinson[MVP]
 
Back
Top