If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Access Question

paconnors · 2013-03-26 13:55:51

Hi There have a slight problem i am doing a project in access and i am building a membership database for a club in a form i am trying to build i have a dropdown box for membership type when i select membership type from list i want the form to insert the fee automatically into the field for it, is this possible here is…

26-03-2013 1:55pm

#1

paconnors

Registered Users, Registered Users 2 Posts: 1,641 ✭✭✭

Join Date: January 2005

Posts: 1422

Hi There

have a slight problem i am doing a project in access and i am building a membership database for a club in a form i am trying to build i have a dropdown box for membership type when i select membership type from list i want the form to insert the fee automatically into the field for it, is this possible

here is the images of form and table

0

Comments

#2 03-04-2013 11:25am

paconnors

Registered Users, Registered Users 2 Posts: 1,641 ✭✭✭

Join Date: January 2005

Posts: 1422

BUMP

0
#3 03-04-2013 11:37am

number66

Registered Users, Registered Users 2 Posts: 92 ✭✭

Join Date: August 2012

Posts: 91

It sure is, You need to write a little VB script that updates the membership dues text box, then link that script to the "afterupdate" event of the "membership type" dropdown list. been years since I used access so can't give you percise details.

http://stackoverflow.com/questions/14944042/set-up-a-form-control-that-updates-when-a-value-in-a-combo-box-is-selected

Just remember to make sure that people cannot enter their own membership dues amount by either disableing that text input field or just using a label instead.

Good Luck.

0