Combo box and labels

[accesslevel]

Hey all

This question has probably been answered over and over again but I'll ask again anyway

Ok, I have one table of customers called "tblCustomers". I created a form (totaly blank), called "frmPurchase" and placed a combo box onto the form called "cboCustomers". I also placed a label called "lblFullName" on the form.

My Question is:

How can I program the combo box so that when a customer is selected, the label shows the Title, Firstname and Lastname as one caption in the label? (Title, Firstname and lastname are all colums in my table)

Regards

 

[Rich]

Scrap the label, add the following to the combos underlying query, Name:[Title]&[FirstName]&[LastName], the field will now display in the combo, to display it on the form add an unbound textbox and set its control source to =[MyCombo].[Column](1)

 

[accesslevel]

Thanks

Thanks mate, that sorted the prob... half the battle when learning something like Access is understanding the syntax and how to send and receive data.

Thanks to you I now know this sort of operation isn't as hard as I thought!

Now that my prob is sorted... maybe you could help me with something else?

Now that I have my Customer selected through the cboCustomer combo box and the full name is displayed in my labels (for reference) how could I insert what the customer wants to purchase by having a list of products which the user selects and then clicks add to add the product to a temporary tblPurchase and then display what is currently in the cart so to speak?