Thread: Listboxes and Add Item
02-07-10, 17:30 #1Registered User
Provided Answers: 1
- Join Date
- Mar 2009
- Gatineau, Quebec Canada
Unanswered: Listboxes and Add Item
I want to use list boxes to assign teachers to individual examinations, The first box would list examinations, the second teachers and the third an examination with a teacher. I have tried loading the third on the afterupdate event -- without success.
Does "additem" and "removeItem" work in Access 2003(it doesn't appear to from my experiments).
Can anyone suggest a useful tutorial?
Guangxi University (currently)
02-07-10, 18:53 #2Moderator
Provided Answers: 19
- Join Date
- Jun 2005
- Richmond, Virginia USA
Additem and RemoveItem works in 2003, but it only works if the Listbox is based on a Value List. They cannot be used on Listboxes based on tables or queries, which sounds as if it might be the case here. In 2003, adding/removing data from Listboxes has to be done by doing thru the underlying table or query.Hope this helps!
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007