Syntax Help Needed Please

C

cvegas

I have added a frame to my form and now want to find a specific record in my
Cash Reciepts table to update the proper balance.

I previously just used
rst.movefirst as this was the only account that we deposited to.

There are only 4 records in the "Cash Receipts" table and they correspond to
the value that would be displayed from the frame.

I guess what I am trying to accomplish is if the value of Frame = 1 then
goto the first record. If the vaule of Frame = 2 then goto the 2nd record,
etc, etc.

I could use help with the syntax to go to the proper record in the "Cash
Reciepts" table.

I'm sure this is easy but not for me.

Thanks in advance.
 
G

Graham Mandeno

You should make the value of the frame correspond to the value of the
primary key in the required record. Then you can use the FindFirst method:

rst.FindFirst "[PrimaryKeyFieldName]=" & Me.NameOfFrame
 
Top