sample VB code for combo boxes

[Trekk]

I have 2 fields both are combo boxes. I need some example code that if one combo box is null no data in it then it will set the other combo box to a default value.

One combo box is populated with usernames and the other is populated with status codes like active unassigned, etc.

If there is not a name in the user combo box then I want the status to read unassigned.

 

[SkipVought]

Hi,

"I have 2 fields both are combo boxes"

Is this MS Word?

Skip,
[sub]
When a wee mystic is on the loose..
It's a Small Medium at Large! [/sub]

 

[Trekk]

Hi Skip

no this is in access on a form, but I guess its all VBA?

 

[SkipVought]

It makes a difference.

Try posting in Forum702 for better results.

Skip,
[sub]
When a wee mystic is on the loose..
It's a Small Medium at Large! [/sub]