Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » How to autopopulate a text field based on a check boxes being ti

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

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

Resolved · Urgent Priority · Version 2007

Reply Wed 1 Dec 2010, 13:26Delegate 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?

For upcoming training course dates see: Pricing & availability

Reply Mon 13 Dec 2010, 09:05Trainer 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

Access articles

· How To Take Control Of Your Data And Save Money In The Process
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Access Corruption Avoidance Tip #1: Split Your Database
· How To Use Concatenation In Access To Create A Custom Lookup
· Discover How To Link An Excel Spreadsheet To An Access Database

Please browse our web site to find out more about
access class ms training and other Microsoft training courses.

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips