By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,316 Members | 2,355 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,316 IT Pros & Developers. It's quick & easy.

List Box Options Not Appearing

P: n/a
I have a subform with two list boxes on it. The first listbox has a
SQL rowsource that builds from one of the tables that lists multiple
work skills (ex - Word Exp, Excel Exp, 10 Key). When end users double
click on values in the first listbox it creates a new record in a
differant table. It pulls the canidates id from the master form as
well as who created it and date/time. The row source for the second
list box is generated from the table that stores the records created
from the first listbox. There is a WHERE statement that pulls only
those records that pertain the active record in the main form. the
values dont appear, though. I can scroll up and down through the
second list box to the exact number of records that were created from
the first listbox. Any clue as to why i cant see them? I appreciate
any help- if more information is needed, just let me know and i will
supply it -Corey

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Check the Listbox properties. The record/row source line will allow you to
view the query results independent of the list box display. Also check the
column widths, list width and bound column#.
-Ed

"Corey" <co**********@yahoo.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
I have a subform with two list boxes on it. The first listbox has a
SQL rowsource that builds from one of the tables that lists multiple
work skills (ex - Word Exp, Excel Exp, 10 Key). When end users double
click on values in the first listbox it creates a new record in a
differant table. It pulls the canidates id from the master form as
well as who created it and date/time. The row source for the second
list box is generated from the table that stores the records created
from the first listbox. There is a WHERE statement that pulls only
those records that pertain the active record in the main form. the
values dont appear, though. I can scroll up and down through the
second list box to the exact number of records that were created from
the first listbox. Any clue as to why i cant see them? I appreciate
any help- if more information is needed, just let me know and i will
supply it -Corey

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.