How to Increment and Move to Next Query's Recordset

  • Thread starter Thread starter DF2008
  • Start date Start date
D

DF2008

I need to setup a db for a Race. It has Heats and Runners. I would like the
form to show one heat at a time and all the participants so I can score them,
then move to the next Heat when I click on a "button".

I assume I need a query to only show each heat with the participants names.

1. How do I connect this query to the form?
2. What do I put in a button that says "Next Heat" to increment +1 and
requery?

This doesn't seem hard, but I just don't know where to start. Does anyone
have any code I can modify that does something like this?
 
You've described "how" you want to do something, but nothing about the
underlying data. It all starts with the data.

It's hard to get "there from here" when we don't know where "here" is...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
What you are describing is a typical parent child form relationship.

A) Main form bound to heats table and form type set to single form and
have heat description/name show as field.

B) place a subform on that form. The wizard will ask you what table
select the runners and then it will ask what relationship and you tell
it how to match the two tables. Design this second child form in
whatever way you want to display the runners and allow you access to
the score.

Almost every example MS Access template has at least one master/child
form relationship set up like this.

Ron
 
Back
Top