I'm trying to do the following:
Enter your name
Enter you password
After submission with button and authentication, populate the appropriate data based off a query on the person's name into a combo box. Any thoughts on how to do this? I'm writing the function/macros with VB through Access.
I'll usually do something like this:
Dim rselect As New ADODB.Recordset
' open connection stuff here
rselect.Open "select data where name = name", cnn, adOpenStatic, adLockOptimistic
Can I push this rselect set into the combo box or is there a better way to do it?