Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / May 2005

Tip: Looking for answers? Try searching our database.

Syntax Help Needed Please

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cvegas - 05 May 2005 22:06 GMT
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.
Graham Mandeno - 05 May 2005 22:23 GMT
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

Signature

Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

>I have added a frame to my form and now want to find a specific record in
>my
[quoted text clipped - 18 lines]
>
> Thanks in advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.