Search code examples
ms-accesstextboxvbaauto-populate

Populate the textbox value based on another textbox - Ms Access

I am trying to poulate a textbox to show a value based on another textbox. I am making a tabulation chart of students result and at the end of each calculation i want the firt record to show the 1st position and the second record to show 2nd and so on. I have performed all the calculation and sort the data to show in Descending format so that the highest marks show on top. Now i dont know how to populate the textbox to show 1st, 2nd and 3rd postions.

Solution

  • Change your form to a continuous form, and then modify the recordsource to use TOP 3 like:

    Select Top 3 * From YourTable Order By [HighMark] Desc

    Or create a new form as a continuous form or datasheetview form using this recordsource, and insert this form as a subform on a new main form.