Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

how autopopulate text field

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

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

ResolvedVersion 2007

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?

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

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.