FindRecord is Failing

[rbehnke]

I have a screen I use to build records in a couple of tables. One table is the recordsource for the form. I use unbound text boxes to enter the initial data and a command button to activate the AddNew processes for building the records in the two tables. The AddNew works fine for both tables.

After the AddNew, I requery the form and set the focus to a bound field and try to perform a FindRecord to find the record I just added to that table. I have other bound fields I want to update. I get the following message:

"A macro set to one of the current field's properties failed becuase of an error in a FindRecord action argument."

Here's my find record action:

"DoCmd.FindRecord Me.txtTPRNo"

It seems like the new record is not in the table yet.

What am I missing?

Thanks in advance!!!

 

[rbehnke]

I never did figure the FindRecord problem out, but I was able to use a Filter to isolate my record instead.