combo box default value from diff table

shiner

Registered User.
Local time
Today, 21:06
Joined
Feb 6, 2003
Messages
30
Hi,
In my preferences table, coaches have the option for setting the primary gender for their team. In forms throughout the database, I would like the default value of gender boxes to use this preference setting.

I have a link to ADD NEW EQUIPMENT ITEM and I want to form to open to a new record. When items are entered, they are associatied with a gender. This allows me to sort and display only items for women if I want to in a report. In the equipment gender box, I want the default value to be preset to the preference listed in the preferences table.

I just made a form to handle inputting new equipment items. Now, the problem comes when the data source is a query as opposed to a table. I can pull in the field prefered_team_gender using the query, but I can not create a new record -- I get errors because it is limiting me to just the query results. But, I can create a new record when the data source is just the table, but I get the ensuing ?Name error when the default value is listed as =[tablename]![prefered.gender].

Any suggestions?
 

Users who are viewing this thread

Back
Top Bottom