SetValue SubForm

P

Paul

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

Visio shape text disappears upon copy paste 1
Adding a record to a subform with a macro 2
ASK Field Formatting 1
Setting a value cause record selection to change 1
Where did the SetValue action go? 5
setvalue macro 1
Continuous Form or Datasheet Subform Setvalue 1
Problem with form--subform 5

Top