database programming in visual basic

hello ,

i am developing a database application using MS access and Visual Basic 6.0.In one of the forms,I have to link 2 combo boxes.
The data in one of the combo boxes depends on the data in the other combo box.

ex. if i choose one value in one combo box then all the corresponding values related to that value should be displayed in the other combo box.

can anybody send me a code for this problem.

thank u

Search on www.mvps.org for some samples of syncronizing combo boxes.

I do't know whether U have some problem in the Vb develop Access db..But i will give U some help.
vb develop access db sample link:
http://www.a1vbcode.com/app.asp?ID=1888

Basically, No.

Sounds like your wanting someone to write the code for you for free. If this is the case, then you should post in the project help wanted forum. If you are wanting to tackle the problem yourself, then we would be more than glad to help you when/if you get stuck.

A good hint as to where to go is in the change event of the first combo box is where you load the conditional data into the second combo box.

Hide or disable the scond combo until the first combo has something in it.

In the "lost focus" event, do a select case for the contents of the second box based on the first.

Private Sub Combo1_LostFocus()
Select Case Combo1.Text
Case is = "Customers": Call LoadCustomers
Case is = "Employees": Call LoadEmployees
Case is = "Vendors": Call LoadVendors
End Select
End Sub