Click here to Skip to main content
14,766,562 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have two items in a form.
First is a textbox and second is combo box.

I have single value in textbox but there is a multiple values for the combobox which depend on the value of the textbox.

When I write in textbox I require an 'ALL' value is available in the combo box.

Can any one solve my problem?

I used MS Access for my backend.
How can I create a table that can be used for a my problem?

Give me any reference or codes.
Posted
Updated 19-Nov-10 23:42pm
v2
Comments
Dalek Dave 20-Nov-10 4:43am
   
Edited for Grammar, Syntax and Readability.

While returning values from the database, you can actually union an all to your source.

For e.g.

select 'All', null <br />
UNION<br />
<br />
select emp_name,emp_age from emp_table
   
v2
Something along the lines of...

if textbox1.value<>"" then combobox1.add("ALL")
   
Comments
Dalek Dave 20-Nov-10 5:29am
   
did this deserve a 1 vote?
it is technically correct.
Tarun.K.S 20-Nov-10 5:31am
   
Reason for my vote of 1:
Completely Wrong answer.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900