.FindFirst with record set

[Locopete99]

Hi Guys,

Can someone explain the workings of .FindFirst?

I'll admit I've been using the .FindFirst that someone helped me with so I dont actually get the workings.

So i now have a new record set that I want to update, but I need to match the record before going forward.

I have used

.FindFirst "[Subba3] =" & "'" & [Subba3] & "'"

Which is just amending the code that I was helped with before.

I have a form where the user enters a piece of data and it enters 3 other fields using calculations.

So the Table that the record set is using has the unique field Subba3 and the form has Subba3.

So how to I get this to select the record in the table that has the same Subba3 record as the record that I am updating on the form?

Currently it is inserting a new row with the inserted data.

 

[Minty]

Your code syntax is a little off try this;

.FindFirst "[Subba3] ='" & Me.Subba3 & "'"

Me. will refer to the form controls rather than the underlying record data.

And if it's adding a record then we would need to see the rest of your code.

 

[Locopete99]

Thanks Minty,

That Syntax change and a change from .Add to .Edit has fixed it right up.