Mark Phillips wrote:
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"
I take it this is a list box and not a combo box - so the query should be
"SELECT "last_name", "player_ID"
FROM players"
Where player_id is the value that you want saved into the table the listbox is
owned by.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
