Urgent!!!! Combo Box Dilemma!!!

Hi Guys,

Can I combine two fields, say last name & first name in just one combobox. I am encountering errors trying to do so. Could you please help me with this?

Thanks in advance and Happy Easter
jay_acboAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
raizonConnect With a Mentor Commented:
the way I do this in SQL is build my SQL statment like so.

sql = "SELECT lname + fname As fullName from Table"
rs.Open sql, conn

If not rs.EOF then
  while not rs.EOF
    cmbData.AddItem rs("fullName")
  wend
End If

but basically the concept is combining the two fields from your database in your sql statment and aliasing them as a single field.
0
 
Ryan ChongCommented:
What is the error appears? any code avaible? ..
0
 
Neo78Commented:
Yes u can....here's a suggestion which u have to modify for it to work for u

With cmbData(0)
    .Clear
    If cRcs.boo_ReadData("LeaveType") Then
      While Not cRcs.rcs_ReadData.EOF
        .AddItem cRcs.rcs_ReadData!TypeOfLeave & _
                 "  : " & cRcs.rcs_ReadData!LeaveDesc & ""
        cRcs.Move NextRecord
      Wend
    End If
End With

cRcs.boo_readData is my function call which is a class module. So based on how u declare your recordset and its connections, u can try replacing mine with yours.
But the main part should look like the line : .AddItem....!TypeOfLeave & _.....

In the example, my table is LeaveType, the two fields are TypeOfLeave and LeaveDesc and combobox is cmbData(0).

Regards.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
CodeWizrdCommented:

The previous answers are all good, except I would trim the fields when putting them together like so:

cboDropdown.additem trim(firstname) & " " & trim(lastname)

This way, your drop down would contain "Rich Smith" instead of potentially "Rich            Smith           " depending on how your database is set up.

0
 
jay_acboAuthor Commented:
actually, i'm using a data combo control....
0
 
Ryan ChongCommented:
Then what's the problem? ..
0
 
Éric MoreauSenior .Net ConsultantCommented:
then use raizon idea: sql = "SELECT lname + fname As fullName from Table"
0
 
DanRollinsCommented:
Hi jay_acbo,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept raizon's comment(s) as an answer.

jay_acbo, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0
All Courses

From novice to tech pro — start learning today.