Click here to Skip to main content
15,881,172 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 22: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
 
Share this answer
 
v2
Something along the lines of...

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