SetValue SubForm

G

Guest

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

Steve Schapel

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.
 

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

SetValue for a Toggle Button on a subform 1
setvalue action changes record focus 5
Tab Control effecting subform setvalue macro 3
Setting a value cause record selection to change 1
Where did the SetValue action go? 5
Hide/Show Subform Continuing Problem 1
Hide/Show Subform 4
Macros in Subforms 1

Top