I want to have a user search the first combo box of a form and then the results of that box give you choices in the second combo box (that part I have working ok), then I want the form to autopopulate form a table for the remaining fields on the form.
Here is what I have:
Me.RecordsetClone.FindFirst "[TIN]= " & Str(Nz(Me![cboFindRecord], 0)) & " And [Request Type]" = " & Me![cboRequestType] & """
Me.Bookmark = Me.Recordset.Clone.Bookmark
Before I had 2 combo boxes i did the following and it worked for the first combo, but then I added the second combo box dependent on the first and my code is not working:
Set rs = Me.Recordset.Clone
rs.FindFirst "[TIN] = " & Str(Nz(Me![Combo256], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
Here is what I have:
Me.RecordsetClone.FindFirst "[TIN]= " & Str(Nz(Me![cboFindRecord], 0)) & " And [Request Type]" = " & Me![cboRequestType] & """
Me.Bookmark = Me.Recordset.Clone.Bookmark
Before I had 2 combo boxes i did the following and it worked for the first combo, but then I added the second combo box dependent on the first and my code is not working:
Set rs = Me.Recordset.Clone
rs.FindFirst "[TIN] = " & Str(Nz(Me![Combo256], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark