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 / Macros / April 2004

Tip: Looking for answers? Try searching our database.

SetValue SubForm

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul - 25 Apr 2004 05:01 GMT
Please Help!!!!

How can I use Setvalue to set the value of the ID (autonumber) of a main form to ID control (number) on 3 Subform whose visible properties are set to NO. The subforms will be visible based upon a selection in a combo box on the main form. Your prompt response is very appreciated.
Steve Schapel - 25 Apr 2004 09:55 GMT
Paul,

You can't use a SetValue action to assign a value to an AutoNumber.  In
fact, normally you do not assign the value to an Autonumber, as this is
done automatically by Access when a new record is started.  As far as I
know, the only way you can control the value of an autonumber is to use
an Append Query to add a new record with the number you want (assuming
there is not already a record with this number assigned.

Signature

Steve Schapel, Microsoft Access MVP

> Please Help!!!!!
>
[quoted text clipped - 3 lines]
> selection in a combo box on the main form. Your prompt response is
> very appreciated.
 
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.