Autopopulate

A

Ananth

I have a table that has 20 Fields

I want a Field to autupopulate.

1 Field is titled UNSPSC Code another field is called Flag
Based on UNSPSC Code, Field Flag is to be populated with Yes or No.

For example if UNSPSC code="9316000" then Flag should "No" . I have to apply
this rule to atleast 10 Codes & would want to expand, which will not exceed
20.

I want to acheive this WITHOUT USING A QUERY.

Any help please



I want to use
 
W

Wayne-I-M

You could use a form and set the AfterUpdate event of [UNSPSC Code] to set
the value of [flag] to either 0 or -1

You say you don't want to use a query but the the form should be based on a
query. In this case I "think" that the form would be better anyway - but you
don't give enough detail to be sure.

Are you trying to update many records (in which case you could use an update
query) or is this something that users will work on in the future ??
 
L

lunwanting

Ananth said:
I have a table that has 20 Fields

I want a Field to autupopulate.

1 Field is titled UNSPSC Code another field is called Flag
Based on UNSPSC Code, Field Flag is to be populated with Yes or No.

For example if UNSPSC code="9316000" then Flag should "No" . I have to apply
this rule to atleast 10 Codes & would want to expand, which will not exceed
20.

I want to acheive this WITHOUT USING A QUERY.

Any help please



I want to use
Click to expand...
 
Top