Text Box Results based on Combo Box and Another Text Box

[cyliyu]

Need help, please!

I have a Combo box in the Form when the field was selected from the list.
I want a Text box 2 to show a result when certain criteria are meet based on the data selected from the Combo box and another Text box 1 info.
e.g.

Case	Combo Box	Text Box 1	Text Box 2
1	APPU	DT1 or DT2 or N.A	ACCU
2	APPU	MP1 or MP2 or MI1 or MI2	APPU
3	MPPU	DT1 or DT2 or N.A	MPPU
4	MPPU	MP1 or MP2 or MI1 or MI2	LPPU
5	PECCU	Don't Care	PECCU

The Text Box 2 will have the same result as the Combo Box if the condition not met.

 

[theDBguy]

Hi. Are you using a single or continuous view form?

 

[cyliyu]

I am using a single view form

 

[theDBguy]

I am using a single view form

Hi. There's really lots of ways to do this. For example, you could use VBA or an IIf() expression in Text Box 2 or create a mapping table and then use DLookup() to get the right value. It would be better if you can add the value in your query, so you can just bind the Textbox to it.

 

[cyliyu]

Thanks, theDBguy.
will try again the query method as I don’t get it works.
will check where goes wrong.

 

[theDBguy]

Thanks, theDBguy.
will try again the query method as I don’t get it works.
will check where goes wrong.

Good luck. If you get stuck, maybe you can post a sample db, so we can help you make it work.

 

[cyliyu]

Attached file the sample and would like to seek help.

In the frmRMA, the field LRU (combo box) and TextBox624 where I get stuck.
When a product was selected from the LRU and TextBox373 (Result based on Combo box319), I would like to have the result as shown in post 1 (Text Box 2).

 

[theDBguy]

Attached file the sample and would like to seek help.

In the frmRMA, the field LRU (combo box) and TextBox624 where I get stuck.
When a product was selected from the LRU and TextBox373 (Result based on Combo box319), I would like to have the result as shown in post 1 (Text Box 2).

Okay. Not in front of a computer right now, but I'll take a look first thing tomorrow.

 

[cyliyu]

Sure. Thanks for your help.