Hi Mark, > I have a form which contains a sub-form. The form is used for data > entry. I want to use a drop down list for one of the fields in the > sub-form. The drop down list takes data from another table not related > to the form or sub-form. I tried the following steps, but the drop down > list is never populated: > > 1. Change the field control to an drop down box > 2. Set the drop-down property of the control to yes > 3. Set the Type of List Contents property to SQL > 4. Set the List Content property to "SELECT "player_ID", "last_name" > FROM players" > > These steps worked for three other controls on this form, so why not > here? > > Is there something that prevents a sub-form control from using sql to > get its table contents?
Is the (logical) form which the control belongs to - see the form navigator - bound to a (valid) table/query/SQL? Also, did this work in previous OOo version? What I could reproduce is that when you have such a list box in a form, where the form is not bound, then the list box doesn't load its data from the DB. This is in fact unfortunate, but has been this way at least since 2.0, some years back (which for the moment just means the severity is decreased). If any of your two answers to the above questions is "Yes", I'd be interested in a) a self-contained document to reproduce the problem or b) a more detailed description of your setup. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
