Syntax Help Needed Please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import from EXCEL selectively 4
Calculate conditiona total at bottom of continuous form. 4
Access Create option group without using wizard? 2
How to create a running total on a table 1
Running Total, Opening & Closing Acct Balance in Cash Book 1
help with syntax 4
My (final) 2 cents on continuous form design 4
Syntax Help 1

Back
Top