View Single Post
  #1  
Old November 5th, 2009, 06:17 PM posted to microsoft.public.access.forms
trying2learn
external usenet poster
 
Posts: 1
Default how do i get listbox selected data into table

I have a form with an unbound listbox (0) set to simple for multi select,
that I populate it from a table that contains boardmembers. the query has 2
fields the boardmemberid and a concatenated field of Boardmember:bmlastname &
" " & bmfirstname. The listbox column count is set to 2 and they are 0",1.5".

The form also has an unbound textbox (name dBdate) set to date() and a combo
box (named cboBoard) that when clicked on has 3 options: board 1, board 2,
Joint.

I would like to get the date, selected data from conbobox and selected data
from the list box to append to a table called tblBmeetings which has the
following fields.

bmeetingid(auto pk)
bmid (number(fK to bmid in tblboardmembers))
Board
BoardMember
Bdate

I would like to do this with a cmd button.

Thanks