help with textbox

[eshai]

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

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

 

[pbaldy]

Try GoToRecord right after the OpenForm.

You might want to revisit all the With/End With blocks.

 

[eshai]

Try GoToRecord right after the OpenForm.

You might want to revisit all the With/End With blocks.

the record go to the last
but the textbox insert the value in first record

 

[pbaldy]

I'm afraid I don't understand. If the form is on the last record, the textbox should affect that record. Can you post the db here along with instructions on how to recreate the problem?

 

[eshai]

I'm afraid I don't understand. If the form is on the last record, the textbox should affect that record. Can you post the db here along with instructions on how to recreate the problem?

tnx for reply
didn't get it what to post and how

 

[pbaldy]

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[eshai]

my db is 42mb i can't upload this size
let me explain the record in the table is moving to the last but the textbox showing the first value of the table. i did "go to record" on every event