opening a new record within a text box feild

[oggstar]

I am editing a form and the curser is within the Feild [number] (Say 1500 is entered). If i change the number to 1600, how can i set the database so the record relating to the number 1600 appears, as opposed to the information relating to 1500 record remaining with the new number 1600 appearing in the field.

Any ideas

 

[nickjar2]

create an unbound text box. It has to be unbound otherwise your record will get updated. On the after_Update of the text box place this code.

dim rs as object

Set rs = Me.Recordset.Clone
rs.FindFirst "[fieldName] = " & textBoxName
Me.Bookmark = rs.Bookmark

This should hopefully work,

Nick

 

[oggstar]

Thanks nickjar2 for teh reply
Still unsure about the code to use, specifically what does & textBoxName refer to.
I thought it refered to the feild name but that was unsuccusful.

This was the code i included, - " & textBoxName

Private Sub Site_Number_AfterUpdate()
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Site Number] = " & textBoxName
Me.Bookmark = rs.Bookmark
End Sub

Thanks

 

[nickjar2]

oggstar,

Sorry. I didn't explain properly.

Private Sub Site_Number_AfterUpdate()
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Site Number] = " & site_number
Me.Bookmark = rs.Bookmark
End Sub

Hopefully this will work.

Nick

 

[oggstar]

Thanks nickjar2 it most certianly works