Adding value to a table from combo box

[KenHigg]

Hum... Hope I'mnot missing anything here...

On your subform, just have one control, a combo box. Set the rowsource to a query base on the employee table, that sorts the names alphabetically. This will provide you with the names to choose. Then set the combo box Control Source to the underlying table's employee name field.

There is one other 'good design' issue you may want to consider. You may want to store the employee id from the employee table instead of the employee name.

ken

 

[Markvand]

Ken,

I'm at this stage already,

I have a joined table with ProjectID and EmployeeID,
I have also a subform with combo to pick Employee (source is set to Employee Table)

When I have a form type set to continues I can have one than more employees per project, so that's the result I wanted to have.

The thing is, I don't want to have continous form, I want to have single combo, pick a name, save it to table, clear the combo, and be able to pick another one.

Hope I am not confussing here.

Mark

 

[Rich]

How will you know which employees have already been selected?

 

[Markvand]

How will you know which employees have already been selected?

yep that's a good remark, I haven't thought about this, luckily I'll only use about 8 employees so you can pay attention who you pick but it's not an option.

It would be nice to worry about this having the first step.

Mark

 

[KenHigg]

Oh well, that whole subfrom drill was to be able to see the names...

???