How to autopopulate a text field based on a check boxes being ti

Resolved · Urgent Priority · Version 2007

Wed 1 Dec 2010, 13:26 Delegate Astley said...

Astley has attended:
Access Advanced course

How to autopopulate a text field based on a check boxes being ti

I have 3 organisations: Fleet Community Cetre, Maitland Park Sports Centre and Queens Crescent Community Centre, now I know the code to autopopulate...however, based on each checkbox being ticked one after the other, I would like the following prices to be auto-populated into a blank deposit text box field. for example:

Fleet Community Cetre will display a deposit of £100.00
Maitland Park Sports Centre will display a deposit of £100.00
Queens Crescent community centre will display a deposit of £110.00 and Equipment will display £100.00

In addiiton, I would like enforce user to only select one checkbox at a time..i'e when they select one check box...the other checkboxes will be nulled...so it's impossible for them to select 2 or all three checkboxes at the same time. Can this be done using access 2007? If so, how can this be done?

Mon 13 Dec 2010, 09:05 Trainer Jacob said...

RE: How to autopopulate a text field based on a check boxes bein

Hello Astley

Thanks for your detailed post.

I have managed to review this with one of our team and we are of the opinion that to provide further assistance will be beyond the scope of this forum.

The next steps would be to review your working files and have one of our training consultants call you to discuss further. We would then be able to identify what work is required and durations.

Please contact us if you are interested to discuss further.

Kind regards

Jacob