0

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: n/a

3
Contributors
5
Replies
6
Views
6 Years
Discussion Span
Last Post by saddas
1

@saddas
if you use rs.MoveLast

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

Votes + Comments
you right, i'm forget to explain about move.last :)
0

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

0

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

0

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

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.