Entering Info From Two Queries

[assassin4213]

Hello Everyone,

Ok, here's the scoop. I have a tournament / player score tracking database that we are developing.

1. I have a form that I would like to use to select a table number. I use a combo box to select this table number. This part is easy.

2. Once I have selected the table number, I would like to have two sets of fields automatically filled with information from two different queries (ie: player #1 and player #2). Each set of fields will include the player name and the appropriate score fields for the event. The majority of the time the data that will show up will only be the player name since we will be receiving scores and entering the information as it comes in. However, this same form could be used to edit player scores.

3. I would like to be able to tab from one field to the next when entering the information. After all of the information is entered, I would like to then hit a button that will write the information back to the two queries.

The problem that I seem to have is trying to enter information from two queries on the same form. Alas, I have been experimenting with unbound forms, subforms and unbound text fields, but have not been able to get anything to work. Would anyone have some suggestions? Any help is greatly appreciated.

Thanks,

Greg

 

[RexesOperator]

Do you really need two queries? You should be able to have all the information on each player on one query. You might look at a structure of one tournament for many events and one event for many players. Then you could use a main form of tournament and two subforms - one for events and one for players.