Default value based on combobox selection

[sadiq92]

Hello

I have one form . I want one of the text boxs default value to be depends on combobox selection. How I can do it ?

 

[theDBguy]

In the AfterUpdate event of the Combobox, you could try something like:

Me.TextboxName.DefaultValue = """" & Me.ComboboxName & """"

Hope that helps...

 

[sadiq92]

In the AfterUpdate event of the Combobox, you could try something like:

Me.TextboxName.DefaultValue = """" & Me.ComboboxName & """"

Hope that helps...

where I put the default value?

for example if the default value is “ London “ , how I put it on the code?

 

[theDBguy]

where I put the default value?

for example if the default value is “ London “ , how I put it on the code?

Hi. I thought you said the default value would depend on what was selected in the Combobox? If so, you don't put "London" in the code. Instead, you select "London" from the Combobox, and the code will pick it up for you.

 

[sadiq92]

Hi. I thought you said the default value would depend on what was selected in the Combobox? If so, you don't put "London" in the code. Instead, you select "London" from the Combobox, and the code will pick it up for you.

no you misunderstand me.

for example , If I select “England” from Combobox , I want thr default value of textbox to be “ london “.

If I select other than England , I want the textbox to be empty

 

[theDBguy]

no you misunderstand me.

for example , If I select “England” from Combobox , I want thr default value of textbox to be “ london “.

If I select other than England , I want the textbox to be empty

No, I don't think I misunderstood what you asked for. Did you try the code I posted? Since you don't know ahead of time what the user will choose from the Combobox, you can't put it in the code. The code I gave you should put London, if the user selects London, and it should automatically put England, if the user selects England. Give it a try and let us know what happens.

 

[Isaac]

It sounds like you want a lookup based on Countries and Cities. Rather than the same value as the combobox. Is that correct?