Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012
    Posts
    126

    Unanswered: Using insert into on a form to sent records to a table

    I have a combo box that is driving our customers by zip code. Basically you select the zip code and all our customers are listed below the combo box in a subform. I am wanting to make the records that are no populated in the subform move into a new customer table i created. Below is the code for the insert into but im not sure what event procedure to put it in.

    Code:
        'add data to table
        CurrentDb.Execute "INSERT INTO tblcustomers(CustomerID, Description, Address, City, Zip, Phone, ChainID, SalesPerson) " & _
            " VALUES (" & Me.CustomerID & ",'" & Me.Description & ",'" & Me.Address & ",'" & Me.City & ",'" & Me.State & ",'" & _
            Me.Zip & ",'" & Me.Phone & ",'" & Me.ChainID & ",'" & Me.SalesPersonID & "')"

  2. #2
    Join Date
    Aug 2012
    Posts
    126
    I figured out how to get this to work, please delete mods

Posting Permissions

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