I have created a list box that uses a multi select but my append query is not adding the items to the table.
What am I missing?
I have created a list box that uses a multi select but my append query is not adding the items to the table.
What am I missing?
You are missing some code or sql to help us understand your issue.
Show us the Append query.
What does the list box have to do with the query?
We only can see what you post.We can't guess what you're doing and give a meaningful answer.
I'm not using any code and I don't think the issue is with my append query because I was using it for a while when the list box was not multi select. The append query is saving several fields from a form and adding them into a table. When I add new records everything is added but the multi select list box items. I initially had it as a combo box but I wanted to change it to a multi select so I used a list box. Every thing worked when I used a combo box too.
My append query is
INSERT INTO TABLE(FIELD)
SELECT DISTINCT [Forms]![FORMNAME]!
[List0] AS Expr1;
Retrieving selections from a Listbox with the Multi-Select Property set to 'Simple' or 'Extended' requires different code than one in which it is set to 'None!' A Listbox with this Property set to 'None' has a Value Property, such as your Combobox did, but one set to 'Simple' or 'Extended,' on the other hand, does not! For those you have to loop through the selections to retrieve them.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007
thank you!
So it is set to 'Simple'
How do I look through the selections?