Auto Populate a Text Box from a Value Displayed in a List Box

G

Guest

I have a List Box that is populated from a combo box.

Now I want to have a text box populated depending on the value seen in the
list box. I tried:

=iff([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")

And, of course, this does not work.

How can I make this work?
 
G

Guest

That what you have
=iff([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")

Instead if Iff change it to IIF
=iif([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")
 
G

Guest

Thanks Ofer,

Can't believe I missed the IFF :))

I fixed it though and I still get the #Name?

Any suggestions?

Ofer Cohen said:
That what you have
=iff([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")

Instead if Iff change it to IIF
=iif([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")


--
Good Luck
BS"D


Nanette said:
I have a List Box that is populated from a combo box.

Now I want to have a text box populated depending on the value seen in the
list box. I tried:

=iff([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")

And, of course, this does not work.

How can I make this work?
Click to expand...
Click to expand...
 
G

Guest

=iif([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")

What is [R]? Is that a text box in the form?
If it's only a value that you want to compare it with, then try

=iif([lstRFQType]="R","NGSS Material Replacement","NGSS COSAL Material
Replacement")

Is the [lstRFQType] field located on that form also?

--
Good Luck
BS"D


Nanette said:
Thanks Ofer,

Can't believe I missed the IFF :))

I fixed it though and I still get the #Name?

Any suggestions?

Ofer Cohen said:
That what you have
=iff([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")

Instead if Iff change it to IIF
=iif([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")


--
Good Luck
BS"D


Nanette said:
I have a List Box that is populated from a combo box.

Now I want to have a text box populated depending on the value seen in the
list box. I tried:

=iff([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")

And, of course, this does not work.

How can I make this work?
Click to expand...
Click to expand...
Click to expand...
 
G

Guest

Hi Ofer,

I thought about your question are realized that R is text in a text box, so
I changed the [R] to 'R' and it works!

Ofer Cohen said:
=iif([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")

What is [R]? Is that a text box in the form?
If it's only a value that you want to compare it with, then try

=iif([lstRFQType]="R","NGSS Material Replacement","NGSS COSAL Material
Replacement")

Is the [lstRFQType] field located on that form also?

--
Good Luck
BS"D


Nanette said:
Thanks Ofer,

Can't believe I missed the IFF :))

I fixed it though and I still get the #Name?

Any suggestions?

Ofer Cohen said:
That what you have
=iff([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")

Instead if Iff change it to IIF
=iif([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")


--
Good Luck
BS"D


:

I have a List Box that is populated from a combo box.

Now I want to have a text box populated depending on the value seen in the
list box. I tried:

=iff([lstRFQType]=[R],"NGSS Material Replacement","NGSS COSAL Material
Replacement")

And, of course, this does not work.

How can I make this work?
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill in table using an iff statement from a sub form 4
POPULATE a textbox based on combo box selection -- QUESTION 2
Populating List box from selection in Combo Box 3
Text Box Calculation Formula 2
Copying List box values/selection to a database of sorts 2
Undo a combo box selection 3
Combo Box Search 4
Variable Font Color in Combo Box 1

Top