Member Avatar for saddas

hello all, i really hope you can help me.
im trying to get a list of customers which are in my database to show up in a combo box but with the code i currently have, it only shows the last record that was entered

rs.MoveLast
With Me.Combo1
.Clear
Do
.AddItem rs.Fields("CustomerFirstName")
rs.MoveNext
Loop Until rs.EOF
End With

under form load^^
using sql
thanks, much help would be appreciated

Edited by saddas because: n/a
  • 3 Contributors
  • 5 Replies
  • 157 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by saddas
Member Avatar for Jx_Man 
Do Until rs.EOF = True
    Combo1.AddItem rs!CustomerFirstName
    rs.MoveNext
Loop
commented: agree +8
Member Avatar for debasisdas

@saddas
if you use rs.MoveLast

you will always get only one (the last) record.

commented: you right, i'm forget to explain about move.last :) +7
Member Avatar for saddas

thanks for response but when i try that code, is says "invalid use of null". do i put the code under form load?

Member Avatar for saddas

i have tried changing it to movefirst and various other things but still does not work

Member Avatar for saddas

dont worry solved it myself, i stupidly had movefirst when i click save and that created a blank line in the database

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.