Help with a form/query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform in a datasheet form that draws the values for a combo box
field from another table in my database. The row source type is
"table/query" so the only possible values that may be entered from the
pulldown are listed in a separate table.
For example, say there are 3 rows shown on the subform TEAM, CITY and
STADIUM. All of this data is already collected in a separate table for every
NFL team. Is there a way that when someone selects a team name it will
automatically populate the correct team city and stadium in the subform
datasheet based upon that table...rather than having to use a pulldown menu
in all 3 of the categories?

Don't know if this question makes sense...but any help is appreciated.
Thanks!
 
yes - but writing VB code to link together these 3 boxes for each city
combination is alot of work.

it would be alot easier to simply merge these three fields into 1 table - -
and then work with a single pulldown
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Subforms in a Form 10
Access Daily Entry with multiple entries per field 0
Problem With Form 5
Query 6
Parameter Value error in a Subform 0
Auto-Populate Combo Box. 15
show data from subform in master form 5
Forms / subforms - queries and tables 1

Back
Top