Linking objects

[John]

Hi,
I`m relitavely new to Access and have designed a small simple database
for collecting information about club members (supporters club) and their
subscriptions/payments.I have it all done except for one last item where I
want to automatically generate "next due date" for subscriptions paid based
on a combobox selection.

Date 1 is "current payment date", Date 2 is "next due date", and these text
boxes are on the subscriptions form. Payment preference is a combo box which
is on the members form, and has 5 different values from weekly to anually.

What I need to do is to automatically populate the "next due date" text box
based on the "current payment date"text box input and the selected "Payment
Preference" combo box value. This seems straight forward enough but I cant
seem to find anyone who knows how to do it. please help.

[Steve]

You will need to use the AfterUpdate event of the Payment Preference
combobox. The code will use Select case statements depending on the values
in the combobox and each case statement will use the DateAdd function to
determine the next due date. So you need to look in the Help file for Select
Case and the DateAdd function.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"John" <lk*******@jhk.net> wrote in message
news:z5*******************@news.indigo.ie...

Hi,
I`m relitavely new to Access and have designed a small simple database
for collecting information about club members (supporters club) and their
subscriptions/payments.I have it all done except for one last item where I
want to automatically generate "next due date" for subscriptions paid based on a combobox selection.

Date 1 is "current payment date", Date 2 is "next due date", and these text boxes are on the subscriptions form. Payment preference is a combo box which is on the members form, and has 5 different values from weekly to anually.

What I need to do is to automatically populate the "next due date" text box based on the "current payment date"text box input and the selected "Payment Preference" combo box value. This seems straight forward enough but I cant
seem to find anyone who knows how to do it. please help.

[John]

thanks Steve
"Steve" <no****@nospam.spam> wrote in message
news:1d****************@newsread2.news.atl.earthli nk.net...

You will need to use the AfterUpdate event of the Payment Preference
combobox. The code will use Select case statements depending on the values
in the combobox and each case statement will use the DateAdd function to
determine the next due date. So you need to look in the Help file for Select Case and the DateAdd function.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"John" <lk*******@jhk.net> wrote in message
news:z5*******************@news.indigo.ie...

Hi,
I`m relitavely new to Access and have designed a small simple database for collecting information about club members (supporters club) and their subscriptions/payments.I have it all done except for one last item where I want to automatically generate "next due date" for subscriptions paid

based

on a combobox selection.

Date 1 is "current payment date", Date 2 is "next due date", and these

text

boxes are on the subscriptions form. Payment preference is a combo box

which

is on the members form, and has 5 different values from weekly to anually.
What I need to do is to automatically populate the "next due date" text

box

based on the "current payment date"text box input and the selected

"Payment

Preference" combo box value. This seems straight forward enough but I cant seem to find anyone who knows how to do it. please help.

[PC Datasheet]

John,

Just want to let you know that I am available to help you if you ever need
consulting help.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"John" <lk*******@jhk.net> wrote in message
news:e3*******************@news.indigo.ie...

thanks Steve
"Steve" <no****@nospam.spam> wrote in message
news:1d****************@newsread2.news.atl.earthli nk.net...

You will need to use the AfterUpdate event of the Payment Preference
combobox. The code will use Select case statements depending on the values

in the combobox and each case statement will use the DateAdd function to
determine the next due date. So you need to look in the Help file for Select

Case and the DateAdd function.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"John" <lk*******@jhk.net> wrote in message
news:z5*******************@news.indigo.ie...

Hi,
I`m relitavely new to Access and have designed a small simple database for collecting information about club members (supporters club) and their subscriptions/payments.I have it all done except for one last item

where I want to automatically generate "next due date" for subscriptions paid

based

on a combobox selection.

Date 1 is "current payment date", Date 2 is "next due date", and these

text

boxes are on the subscriptions form. Payment preference is a combo box

which

is on the members form, and has 5 different values from weekly to anually.
What I need to do is to automatically populate the "next due date"

text box

based on the "current payment date"text box input and the selected

"Payment

Preference" combo box value. This seems straight forward enough but I

cant seem to find anyone who knows how to do it. please help.