add fields from form into a table

Posted on 2011-04-25
Last Modified: 2012-06-27
I have had help with this form - entering the serial number in textbox -hit enter and having it fill a listbox- then finally adding numbers from listbox with command button into table.

Now problem is I have -is having other fields ( shipDate,Run,chk1,chk2,chk3,chk4, CVSKey be added into table -with the serial number. and is it possible?
thank you
Question by:davetough
    LVL 84
    The simplest way is to base the form on your table, then add controls to your form that are based on the various table fields. If you "bind" them, Access will manage the data work for you.
    LVL 44

    Expert Comment

    Easiest if those additional fields are already in the table. Can you explain why they are not?
    LVL 10

    Accepted Solution

    See the attached database. I've updated the Add Record code so it will add all fields on the form to the table as long as the control name on the form matches a field name in the table.
    LVL 30

    Expert Comment

    Tried the attached database in the solution. It did not work!. It gives can't save error.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now