Form Fill from ComboBox, with a twist

[lenp00]

I am filling Form fields from a ComboBox; all that works wonderfully, however...

three of the fields manipulate values from other fields (stripping out certain portions); that works fine

my dilema is that when the form is opened all fields are blank EXCEPT I get #ERROR showing up in the three fields. I would like all the fields to be blank.

I have tried 'initial value', OnLoad etc, etc and am still scratching my head.

Any thoughts???

TIA,
Len

 

[ListO]

The three fields with #ERROR are trying to calculate an entry but are receiving bad input to their calculation, thus the ERROR.

You COULD make their source conditional, by using an iif() statement. Such as:

iif(len(field1)<1,"",your_calcuation_here)

 

[lenp00]

but they work as soon as I choose a record from the drop down...
it's only on first loading the form that the #ERROR shows

 

[lenp00]

Sorry, the rum spoke before the brain kicked in, LOL. I will give that a try and let you know.

Before forget... thank you!

 

[lenp00]

Actually, I'm not sure if I can use that IIF in the Control Source for that field. Unless I'm missing something, this isn't working...

iif(len(txtNNN)<1,"",cmdGetNet([txtMainLANSubnet],"Main"))

Thanks again!