Real New-Real Green-Really over my Head HELP Anyone-Have a Monday deadline?

This may seem nuts but i am really over my head. I have VB6 & Access2002. Learned it outr somewhat over the last 2 weeks. And now I need help.................................................................

I have figured out how to get a great working Drop Down Combo box in Access but when it comes to VB6 SP5 I can get a box but can't link it to a record set? 2 days searching on the internet and nothing.

I had created project through the use of the application wizard but for some reason I am unable to pin point how to get the Drop Down Combo Box to see the Access Database... Any Ideas?????

Database Programming with Visual Basic 6 printed by Sams. This book should get you up and running. ISBN # 0-672031409-6
...
After you create the drop down box you will need to assign a datasource to it. Then you can assign the query to populate the drop down box.
...
The properites box of a combo box should have
DataMember
DataSource
These are the ones you need to link.
...
If you are doing the form programmatically you could query the database and add items as you return the result set.

Funny you should suggest SAM's. I have spent 2 weeks on SAMs Visual Basic in 24 hours............. Maybe its 24 days?

Seriously, I researched and could not find any thing in enough details on making the connections?

When I used the Wizard every thing came in as a text box. And the data is in the text boxes. What i need are a few of the text boxes to be setup as a drop down combo box.

I do have some data fields that exceed 500 items. A drop down would bew best suited.

I could get it to work in Access but no such luck here in VB6. Access was cut and dry. This doesn't appear to be the same.

I just tried to enter the info in the Drop down box and it wouldn't do more than accept the typed wording..... No transfer into the data base....
I must be missing some thing simple...........

I find this answer the rest of the week end will go smooth. If not it'll be a long one.

The book referenced is specific to database programming and Visual Basic and deals with the subject you are in need of. Are you needing to deal with the data display or the data update?

Really Both: I can get the Drop down on the form but I can't quite figure the method to connect to the dataset.

The properties are set as follows:
Style Drop Down Combo
Datasource Datalink1 (Tried connection1 earlier)

I had verified that I am connected and I can see i am on the other text boxes as they are accurately accessing the data. This of course is the text boxes. There are a few I need to change the text boxes to the drop down.

I am really confused.

I was suspecting there was a binding Issue. Somewhere I had picked up that once you use the wizard to generate the applications and the text boxes were assigned they are binded. And then some where I didn't understand was the drop box combo can't be setup.. I don't really understand it fully.

I saw someplace there is another combo control "datacombo", Is there any additional information where and how i can obtain enough info to work it?

i had tried the code that I found posted somewhere else posted and some thing did happen though. I did not get a compile error as usual but when I ran the application I could scroll the rest of the page dataset as usual and all is fine to this point. Nothing in the drop down combo box, As soon as i enter and data and make any move the application crashed.

I got a runtime error :-424 Object Required

Private Sub DropComboBoxList_Change()
Dim curSelTxt As String
****The Next Line Item was in issue with debugging *****
curSelTxt = cmbItem.List(cmbItem.ListIndex) 'getting the current selected item of the combo box
****The Above Line was the issue *******
'the current selection of combo box will be stored in curSeltxt
MsgBox curSelTxt
End Sub

Any one have any soultion?

Here is some code snippet. This is not using data binding but dynamically connecting to the database. Let me know if you have any questions.

Public Function loadComboBox()
Dim myRS As New ADODB.Recordset
Dim i As Integer

Set myRS = New ADODB.Recordset
'Place your database connection here

myRS.Open "SELECT firstname, lastname from sometable"
If myRS.BOF And myRS.EOF Then
MsgBox "The recordset is empty.", 16, "Empty Recordset"
Else
myRS.MoveFirst
For i = 1 To intRecordCount
Me.cboUsers.AddItem (myRS.Fields("firstname") & " " & myRS.Fields("lastname"))
myRS.MoveNext
Next
myRS.Close
End If
Set myRS = Nothing
End Function

Have you tried using the ADO DataList combo control? It's the one I generally use for data-bound dropdowns. Add the Microsoft DataList Controls to your project Components and you'll have the data combo available in your toolbox.