Insert specific data based on the text box it is going into

[NDayave]

How do,

I have a form with a number of textboxes that hide and unhide depending on a number or Laps of a Race. Currently I have this code to make them hide and unhide:

Dim LapBox as String
 
For x = 1 To 9      'For each possible lap
    LapBox = ("txtLap" & x)     'Reference the specific lap's textbox
        If Laps >= x Then       'If the text box is required
            With Me(LapBox)     'Using the Specific Textbox
                .Visible = True 'Make it visible
            End With
        Else                    'If it is not required
            With Me(LapBox)
                .Visible = False    'Make it invisible
            End With
        End If
Next x                          'Go to next text box

What I want to do is, based on what the lap is and which Race Driver is selected, bring up their Stored Lap Time in the text box. I know that this is not the best way to display the time, but it is necessary to be able to edit the time is needs be.

The RaceDriverID comes from lstRaceDriver and the Lap is relative to the text bos it is going into, ie: Lap 1 time goes into the 1st text box, and the Lap Time is stored in tblLapTimes along with the RaceDriver ID, Lap number and LapID.

All help is much appreciated,


NDayave

[FishVal]

Hello, NDayave.

Does it all mean that data for different laps is stored in single table record?

Kind regards,
Fish.

[NDayave]

Thanks for the response, but I have managed to sort this one out.

Thanks anyway,

NDayave

[FishVal]

You are welcome .