u can either do it by filterin form B or by searchin the recordset and then setting it by a bookmark.
easiest thing would be the filter
code in form a:
form_B.filter="Client='" & me.txtClient & "'" ' u could also use a like filter
or u could use this function:
Public Function showMatchingRecord(ActiveForm As Form, Criteria As String) As Boolean
Dim rs As DAO.Recordset
Set rs = ActiveForm.Recordset.Clone
If Not rs.NoMatch Then ActiveForm.Bookmark = rs.Bookmark
showMatchingRecord = Not rs.NoMatch
Originally Posted by YZF
Is it possible to make in current form, after button press, to open new form and go to record where textbox "Client" is equal to current open form's textbox "Client" ?
form A, txtClient = xxx
after button press, opens form B and goes to record where txtClient = xxx