If info is put in to one text box, it must show something else in a other textbox 2

[hendrikbez]

I have a access 2010 form, on it is a few textboxes and dates boxes.
I need when I put type info in first textbox eg. AGG666 and get to the other textbox, it must then show "UNIX" in it.

Here are the code I have, but it does not work, I am not good in vba at this moment.

first textbox name is Tape and control source is Tapes
Other textbox name is cmdsystem and control source is system

I do not think this code is correct to use, how can I do it so show the info I need in the other textbox

Private Sub cmdSystem_Click()
Displaytext = IIf([Tapes] = "AAG666*", "UNIX", "KK ")
End Sub

How will you spend eternity - Smoking or Non Smoking?

 

[PHV]

What is Displaytext ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hendrikbez]

I am not sure, I did google and got it from there, That is wy I am thinking it is wrong, and I do not know how to get it to work

How will you spend eternity - Smoking or Non Smoking?

 

[PHV]

Get rid of the Click event procedure you posted.
In the AfterUpdate event procedure of the Tape control:
Me!cmdSystem = IIf(Me!Tape = "AAG666", "UNIX", "KK")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hendrikbez]

Thank You, that is working, but is this possible to do.

I have more than 300 Different tape numbers and 3 systems, the 4 tape numbers that is for UNIX is AAG001 - AAG100, NSW001 - NSW100, NJQ001-NJQ120 and PRA001 - PRA100. How can I make this if I put only any one of this, it will change the other textbox to UNIX. Also 2 more systems Windows VM and Windows GP and they also have different tape names (not one of the tapes numbers will be the same for any system.

Hope this is possible


How will you spend eternity - Smoking or Non Smoking?

 

[PHV]

I'd use a table with 2 columns: Tape(PK),System
And then you may use joins in the queries and/or DLookUp in the forms.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hendrikbez]

Ok I will try it, I do have a table with Tape and a table with Systems, but will try to use joins.

Thank You

How will you spend eternity - Smoking or Non Smoking?

 

[hendrikbez]

Hi
Do you maby have a sample of how to do this, I do not understand it, and I do not know vba very good.

How will you spend eternity - Smoking or Non Smoking?

 

[randy700]

You need to create a SINGLE table with both data items.

[pre]Tape System
AAG001 UNIX
AAG002 UNIX
AAG003 UNIX
SOMETHING WINDOWS VM[/PRE] etc



Randy

 

[hendrikbez]

thank you for helping me, I will do this now. what is next

How will you spend eternity - Smoking or Non Smoking?

 

[hendrikbez]

Table done

How will you spend eternity - Smoking or Non Smoking?

 

[PHV]

In the AfterUpdate event procedure of the Tape control:

 Me!cmdSystem = DLookUp("Tape", "[name of your table]", "Tape='" & Me!Tape & "'")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hendrikbez]

PHV
Thank You for your help on this, it is working

How will you spend eternity - Smoking or Non Smoking?

 

[PHV]

Sorry for the typo:

Me!cmdSystem = DLookUp("[highlight #FCE94F]System[/highlight]", "[name of your table]", "Tape='" & Me!Tape & "'")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[hendrikbez]

Thanks I did see that it was wrong, I did change it, and it did work.

How will you spend eternity - Smoking or Non Smoking?