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 there a log file somewhere that contains information that might help me diagnose this problem? I am using the latest base/openoffice from the OO web site - 2.4.0 with mysql as the database engine and JDBC. Thanks! Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
