Hello everyone
I built a database of maintenance. Database work so that students report a fault by a few simple clicks on the buttons. The buttons have fixed values like location, sub-location, type of fault
I used this code
Now my question. The following form contains a text box
And I need him move to the last record to put some value
as you see i'm working on dao
I built a database of maintenance. Database work so that students report a fault by a few simple clicks on the buttons. The buttons have fixed values like location, sub-location, type of fault
I used this code
Code:
Private Sub pic5_Click()
Dim rstCategories As Recordset
Set rstCategories = CurrentDb.OpenRecordset(Name:="my table name", Type:=RecordsetTypeEnum.dbOpenDynaset)
With rstCategories
With rstCategories
End With
With rstCategories
.MoveLast 0
End With
With rstCategories
.Edit
![faild name] = "fault name"
.Update
End With
End With
DoCmd.Close ObjectType:=acForm, ObjectName:=Me.Name
DoCmd.OpenForm FormName:="next form", View:=acNormal
End Sub
Now my question. The following form contains a text box
And I need him move to the last record to put some value
as you see i'm working on dao