Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Atlanta, GA
    Posts
    58

    Unanswered: Insert values from one form to another

    I have an order details form and when I click the save command I want it to update some of the values to another form. I have the following code and it states that it can't find the form.

    Forms!frmSubVehicle!txtStockNbr = Me.cboStockNbr

    What am I doing wrong?

    Thanks...

  2. #2
    Join Date
    Feb 2004
    Location
    Canada
    Posts
    133

    Re: Insert values from one form to another

    Originally posted by odamsr
    I have an order details form and when I click the save command I want it to update some of the values to another form. I have the following code and it states that it can't find the form.

    Forms!frmSubVehicle!txtStockNbr = Me.cboStockNbr

    What am I doing wrong?

    Thanks...
    If frmSubVehicle is a SUBFORM on another form you have to reference the main form as well.
    Forms!MainForm!frmSubVehicle.txtStockNbr = Me.cboStockNbr

    Also, frmSubVehicle has to be the name of the subform CONTROL that the subform sits on, which isn't always the form name.
    Last edited by bmacr; 03-20-04 at 00:04.

  3. #3
    Join Date
    Mar 2004
    Location
    Atlanta, GA
    Posts
    58
    Thanks.. I knew it was something simple..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •