Auto Populate

[imagranny]

How can I auto populate a field? I want to input data in field A and have it automatically put information into field B based on my answer in field A.

Thanks.

 

[gnt]

You would need to attach code to the afterupdate event of your first field.

Can you be more specific? What is it exactly that you want to do?

 

[imagranny]

I want to enter a code and have a description populate another field.

Example:
Error Code Description
KMPN Member Not Found

I want to enter the KMPN and have the description automatically populate the description field.

Thanks

 

[gnt]

I assume you have a table or query which contains:
Field 1: Code
Field 2: Description

Set an unbound combobox code field's (cboCodes) rowsource to this table/query. Then set these properties:
Column Count: 2
Column Widths: 2";0"
Bound Column: 2

The code will display in the combobox but the actual value of the field will be the description. Now create your description text box (txtDesc).

In the afterupdate property of the cboCodes, click the ... button, choose code builder, and type this between the Subs:

Me!txtDesc.Value = Me!cboCodes.Value

What this does is set the value of the textbox equal to the value of the combobox, which, remember is the actual description.

I hope I was correct in my assumptions. If not, please provide more detail.

Good luck!