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.
Updated 19-Nov-10 23:42pm
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
Something along the lines of...

if textbox1.value<>"" then combobox1.add("ALL")
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