Comboboxes Issues

[Beany]

Hi,

On my main form AssetMain, there are three comboboxes (selection shows info in a subform)..these combos are acting weird, can someone please have a look? i cannot work it out...

If i use one of the comboboxes it works fine, but if i try another, it just gets confused!!??

Ive attached my database

thanks in advance

 

[boblarson]

Hey Beany:

You have to make sure to set your other booleans as false because if you select the first one, the blnUser is still going to be true and so your code will try to find the user, even though you selected a department.

So, in all three after update events for the combos make sure to set:

blnUser = whatever
blnDept = whatever
blnSite = whatever

 

[Beany]

Hi Boblarson,

ive tried that, but the second and the third combobox doesnt display some of the selections??

 

[boblarson]

What do you mean? I tried it and it seemed to work fine. What selections aren't they showing?