Display Last Record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table "Scores" in which I have the fields "Date" and "Location". I have a form "frmscores" which is used to enter today's scores. The fields on this form are as follows
1. combo box "cmb_location" for selecting the location,
2. text feild "txt_score" for entering the score and
3. another text field "txt_previous" which displays the last updated score for that location (button cmdSave to save the record).
Now when the user selects a particular location, I have to write a code in the after_update event of the Combo so that it displays me the previous score of that location in the "txt_previous". I have tried using clause where location=cmb_location.value and date=date-1 but this will work only if there is a entry everyday and will not work for saturday and sunday(when there will be no entry).
I have to write a code to display the last updated score (last entered score) for the location selected. Please help?
 
Sahil,

Try something like Date=DMax("[Date]","Scores","[Location]=' " &
[frmscores].[cmb_location] & " ' ") to get the date of the last score
entered for the particular location.

HTH,
Nikos

Sahil said:
I have a table "Scores" in which I have the fields "Date" and "Location".
Click to expand...
I have a form "frmscores" which is used to enter today's scores. The fields
1. combo box "cmb_location" for selecting the location,
2. text feild "txt_score" for entering the score and
3. another text field "txt_previous" which displays the last updated score
Click to expand...
for that location (button cmdSave to save the record).
Now when the user selects a particular location, I have to write a code in
Click to expand...
the after_update event of the Combo so that it displays me the previous
score of that location in the "txt_previous". I have tried using clause
where location=cmb_location.value and date=date-1 but this will work only if
there is a entry everyday and will not work for saturday and sunday(when
there will be no entry).
I have to write a code to display the last updated score (last entered
Click to expand...
score) for the location selected. Please help?
 
Back
Top