Also,

If you have a calculation in a field such as

Balance:Invoices-Payments

you can rewrite it like this in your client

Balance:if(isnull(Invoices),0,Invoices)-if(isnull(Payments),0,Payments)

Also,

I've put break points in my code before and then removed them only to have the code break at that exact point.  Usually doing a compile on the project...

I've found the solution (workaround).

I explicitly defined a DAO recordset and then set it to the form's recordset

      Dim rs As DAO.Recordset

      Set rs = Me.Recordset

      rs.Requery

      Call rs.FindFirst("[ptyrfnbr] =...

Thanks for the info.  However, to make things more fun I took the bookmark out of it.

I'm using this in the combo box with the string explicitly set

  Me.RecordSource =...

Initially none.

e.g. select * from party where ptyrfnbr = 0

Then I have a public function call GetRecords that's called by another form.

This then does a "select * from party" and...

OK.  It might be the bookmark bug as well.  A little more info.

If i take my form and have a rowsource of "select * from party" and then do the...

Thank's so much for the reply.  Unfortunately I tried that (but forgot to mention it).

This form is just newly opened and no deletes have occured in the form or the...