Combo Box

[krai]

[Edited]
Hallo All
Im in great need of assistance.

In my database there is a combo box, a drop down box with names.
The form (Tabular) itself is made from 1 table with items, i have 7 different items, and 1 table with names.
In the combo box, i want to change one name, but when i change a name, alle the names, in the combo boxes change.

the form is one line
[item name] [item number] [name]

[TheShabz]

Can you rephrase that? I'm not sure what it is you want.

[krai]

sorry i was very tired when i wrote my post, had been working on it for a long time, so there was a lot ot type mistakes, also englist is only my second language.
Hope you can help me.

[TheShabz]

From what I understand, you have a combobox that has a list of names and you want to change one of the names. For example:
From
Name1
Name2
Name3
To
Name1
Name4
Name3

If so, you just change the name in the table that you are pulling the names from either manually or via an UPDATE query.

[krai]

This i how the form is of now.

[Item 1] [Number1] [Name 1]
[Item 2] [Number2] [Name 1]
[Item 3] [Number3] [Name 1]
[Item 4] [Number4] [Name 1] I can't just change one, i change all. from 1
[Item 5] [Number5] [Name 1] to 2 all at the same time.
[Item 6] [Number6] [Name 1]
[Item 7] [Number7] [Name 1]
[Item 8] [Number8] [Name 1]

All the [name x] = combo boxes.

I get a combo box with the list of names and then the items remain the same and in same place, i want to be able to change one name in one of the combo boxes, without all the names change.
I have one table with 8 gps, and one table with names, military ID numbers and phone numbers, that i want this to work in.

This is what i want
example:
[Item 1] [Number1] [Name 1]
[Item 2] [Number2] [Name 2]
[Item 3] [Number3] [Name 6]
[Item 4] [Number4] [Name 5]
[Item 5] [Number5] [Name 1]
[Item 6] [Number6] [Name 4]
[Item 7] [Number7] [No Name]
[Item 8] [Number8] [No Name]

Thanks very much for the replys so far.

[TheShabz]

So youre looking to update the names on the form based off the name in the combobox. I am assuming 2 things. First that the form is getting its information from a table (called myTable for our purposes). Second, that the combobox is called cmbName.

You will need something else to reference which line you want to change. So a second combobox holding one of the other fields, probably Item. Lets call this combobox cmbItem

So, the variable holding the SQL in a VBA environment would be
strSQL = "UPDATE myTable SET Name = " & Me.cmbName & " WHERE Item = " & Me.cmbItem

This will change the Name field to whatever is in cmbName of only the record that has Item = cmbItem.

hope this helps

[krai]

Thx thx thx. soooooo much.
im so happy, coz my database is working now.
well i still need to get a date, time-group shown for a button press. i have a timer running just need it to take a copy of it and show it on a button press.

[TheShabz]

No problem. If that took care of your question, please mark the thread as "solved" so others can benefit as well.