Simple problem. Newbie Question

[thalor]

I'm sure it's been addressed before, so I apologize in advance.



I'm trying to set fields from a dropdown list in a combobox

The form (ContactList) that the combobox (combobox1) references has

First Name, Last Name, ID

What I want to do is when selecting the Name of the Person, to set another field on the form (ContactID) to be the ID of the person selected.

Simple, but I have not a clue on it. I've searched google using terms I thought would be close to no avail....so again I apologize if this has been answered here.

An answer or a link to another article would be most helpful!

Thanks

[rpeare]

if that is how your data is laid out in your combo box (First name First, Last Name second and ID third) you want your BOUND COLUMN setting of your combo box to be column 3.

[thalor]

Well I forgot to mention (my fault) I need to set a different field with the ID while the bound part is the Last Name. Sorry about that, but thanks for the reply!

[rpeare]

do *NOT* set the bound column to anything but the ID field, you are asking for a world of trouble if you do.

For instance
Kate Smith has ID 1

If kate smith gets married and changes her surname to Jones and are adding data to any tables using the LAST name, you will orphan everything related to Kate Smith.

Further, if you have 15 Smiths at your business there is absolutely no way to determine which smith you are talking about when you look at your child tables (any table where the employee is referenced other than the employee table that has the ID field).

the BOUND field does not mean that's the field that's visible, it just means use the value in column X when you store the data.

[thalor]

Got it. Thanks for that tip! Is there any way to concatenate the First and Last Names in the Combo box?

[rpeare]

Yes:

PersonName: [Lastname] & ", " & [FirstName]

[thalor]

Sory to keep bothering, but you seems to be an expert on this....

With the press of a button how would I create a new record in a table (Shows-People) with the relevant fields on a form.

Fields are : ShowName,ContactID,Position

The fields in the table are named the same as the form.

[rpeare]

You shouldn't need to press a button at all

if you create an UNBOUND combo box that lists all your contacts where the CONTACTID is in the BOUND column, create your form based on a SQL statement or QUERY where the criteria of the CONTACTID field is

[forms]![formname]![comboboxname]

then in the ON CHANGE property of your UNBOUND combo box put in the code

me.requery

Every time you select a new person from your combo box their record will be displayed.

[thalor]

I get what you are saying, what I want is to select data from those comboboxes and put it in another table (not where the comboboxes are getting the data)

IE
I select
"Show 1" from Show
"223" from ContactID
"Admin" from Position

now on that form I see the data but I want to PUSH these 3 things to another table (Shows-People) to create an all new row in that table.

I hope Im explaining myself well...Access programming is very new to me

Thanks

[June7]

Build a form bound to Shows-People (set form RecordSource property). Bind comboboxes to the fields of Shows-People (set ControlSource property). Value selected in combobox is saved into record. This is basic Access functionality.