adding more fields to form to add to table

Posted on 2011-04-26
Last Modified: 2012-05-11
this attached database - if you open - you will see you can enter multiple serial numbers into table-
problem entering other fields - which are not multiple-
like modelNumber - I placed on form
is this possible to have modelNumber and other fields populate fields where multiple serial numbers are added?
I asked similar question- but i only now realize what I am trying to do-
If i just bound form to table- then listbox does not work like i want
thank you

Question by:davetough
    LVL 77

    Accepted Solution

    You need to modify your sql command to include the fields and datab values you want to insert.

    Author Comment

    can i do that and still have listbox enter more than one item?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    Title # Comments Views Activity
    How can I encrypt/decrypt a variable 2 26
    Concatination in Query Problem. 38 46
    MS Access question 11 39
    Aggregate Function error 3 26
    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    758 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

    9 Experts available now in Live!

    Get 1:1 Help Now