listbox doesn't update table

[Jimmy Tran]

Hi everyone,

I have a form consisting of a combo box and two listboxes, they get
their control source from a query. the whole form suppose to update a
table. when i run the form, i pick an item off of the combo box and hit
on refresh. It seems the only thing gets updated into the table is the
item from the combo box. the listboxes data doesn't get updated into the
table. I click on both of it and it does get updated into the table. but
i dont want to click on the listboxes, how can i make them update the
table?

Thank You,
Jimmy

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Rick Brandt]

"Jimmy Tran" <hu*******@yahoo.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

Hi everyone,

I have a form consisting of a combo box and two listboxes, they get
their control source from a query. the whole form suppose to update a
table. when i run the form, i pick an item off of the combo box and hit
on refresh. It seems the only thing gets updated into the table is the
item from the combo box. the listboxes data doesn't get updated into the
table. I click on both of it and it does get updated into the table. but
i dont want to click on the listboxes, how can i make them update the
table?

If you are not making a selection in the ListBox just how is Access
supposed to know what to store? Like any other bound control the value of
the ListBox is Null until you make an entry in it.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com