The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Auto populate fields

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

Auto populate fields

Resolved · Low Priority · Version 2003

ReplySun 7 Feb 2010, 18:03Delegate Tony said...

Auto populate fields

I am using a form to add new records. The first field is populated using a combox that takes its values from another table. The value of this field will be the same in a series of enteries so I want to auto populate it based on the last record. I have added a line of code to set a varialble the first time the value is selected in the combobox and then tried to set the default value with the variable name in the properties window. However, I am not sure how to put a varaible name in the expression builder as it does not seem to recognise the name.

For upcoming training course dates see: Pricing & availability

ReplyFri 12 Feb 2010, 16:28Trainer Stephen said...

RE: Auto populate fields

Hi Tony

Thanks for your question

You are trying to accomplish something that requires VBA code that runs when you update the first combo box. It will have to create an SQL string, with the variable embedded in it, and then sets the second combos row source property equal to it.
You cannot use the expression builder to accomplish task

Regards

Stephen

Access articles

· Discover How To Link An Excel Spreadsheet To An Access Database
· The Easy Way To Get Started With Access
· Guide To Adding A Text Box Form Control In Access 2010
· How To Sort And Filter A Table In Access 2010
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps

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

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

Hi, I am trying to create the following for a report:

I have a row of 16 cells, each cell needs to represent 6.25%. So each time any of these cells are marked with a '1', it will deduct 6.6% from a total score of 100%

Please can you help?

Thank..

» Forum post: Formulas

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions