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 / General 2 / June 2007

Tip: Looking for answers? Try searching our database.

SetValue Subform Records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
F1stman - 15 Jun 2007 21:35 GMT
Hello,
I am trying to run a setvalue macro with the press of a button on a parent
for which will cause toggle the values of a field in the subform between
positive and negative numbers. When I simply run a set value on that field,
it toggles the first record but no others.

Is there a way to run the macro so that ALL subform records are changed?

FYI: This form toggles between debits and credits under a specific invoice
where seperate accounts are used to pay it.

Many thanks in advance!

Adam Kemp
KARL DEWEY - 15 Jun 2007 22:05 GMT
You will need to run an update query using main form Master/Child link
information as criteria.
Signature

KARL DEWEY
Build a little - Test a little

> Hello,
> I am trying to run a setvalue macro with the press of a button on a parent
[quoted text clipped - 10 lines]
>
> Adam Kemp
 
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.