Question-Combo-Box

[rockrider]

Hello all.

Imagine this structure:

table1 (clientID, clientName, clientColor)
form1 (several subforms)

Table1 has several clients but neither client has a value for ClientColor yet.

When I open form1, it loads information from only one specific clientID without the possibility to pass from one clientID to another. That is working.



What I must do now is, to create a combo-box in form1 with the values (green,red). That combo-box must store the values on table1 (field: clientColor). So that, when I open form1 with the information for clientID=1, I want to pick the value "green" in the combo-box, click on a button to save it and store the value "green" on table1 (clientColor).

I'm stuck with this, I'm, sure its quite simple. Many thanks in advance

[alansidman]

Look at this web site and scroll down to the three tutorials on combo boxes.

http://www.datapigtechnologies.com/AccessMain.htm

Alan