SetValue SubForm

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
Back
Top