Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display record number in hidden text box

Status
Not open for further replies.

Nilgni

Instructor
Feb 21, 2002
58
US
I want to use the record number to be a part of an equation. I need to display bout numbers in an 8-man wrestling bracket.

I want to use the record number to determine how many bouts in total we have wrestled to that point.

For example: 1st round, 4 matches, 2nd weight class would be 5 matches so far. 2nd round if there were 16 weight classes would be 16 * 4 + 1 and so on.


Another example:
2 (2nd weight class) * Number of bouts in a round + 1 = the first bout number in the second round.

I need to reference the record number in order to do that. How can I put that number on a form.

Thanks for the help.
Keith
 
Found it.

In the forms On Current Event

Me.BoutNumber.Caption = Me.CurrentRecord * 1 +1

Works
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top