Combo Box + Add Button!!!

  • Thread starter Thread starter Richard C
  • Start date Start date
R

Richard C

Im trying to create a simple add function for a meetings
recorder. I want to list all the people in the database in
the combo box. Then have that combo box linked to a
button, that when pressed will add the persons name
selected to meetings_attendance field.

How can you link a combo box to a button? and what sort of
field would It have to be added to? Would you have
multiple fields? e.g. staff1, staff2, staff3 etc

Richard C
 
Add this to the After Update event of the combo box.

Me.meetings_attendance = Me.ComboBoxName & ";" &
meetings_attendance

watch for word wrap

Have a nice day

Jim
 
I have entered that code, but it becomes highlighted in
Red and doesnt compile. I made my adjustments entering my
variable names and stuff, but it doesnt like the code!!!

Rich
 
Try typing in vb and let the system fill in the fieldnames. when you type
me. a popup list for you to select the Meetings_Attendence. select it and
keep typing the rest of the command and you will be promted for the next Me.
.. for the conmbobox name.

The following statement should be on one line
Me.meetings_attendance = Me.ComboBoxName & ";" &
meetings_attendance

Jim
 
Back
Top