I have two forms. The first form (Dollar Stream) contains billing address info that the user fills in. The second forms (Missing Data) pops when any billing records have missing data. When a user double clicks on the request id in missing data form, the other form opens and moves to that particular record so it can be fixed.
Here's the issue. The first form opens and moves to the record but the user can't move to another record in the Saleslist (listbox). The message "critical error" appears. How can I change it? Here is the code on Form One:
Also, Saleslist is an unbound listbox that contains all request ids entered:
Private Sub SalesList_Click()
Dim mSale As Long, rs As Recordset
On Error GoTo SalesListClickErr
Set rs = Me.RecordsetClone
mSale = SalesList
rs.FindFirst "[Request ID] = " & mSale
If rs.NoMatch Then
MsgBox "Critical Error"
Me.Bookmark = rs.Bookmark
Code on form two to open form one and find the request id.