Access 2007 Question

Posted on 2012-08-14
Last Modified: 2012-08-15
Hi Everyone,
I got to somehow enter a Vendor Name and Store Number only once on a form and  move this same same Vendor Name and Store Number throughout the order form.

I will have a form come up for the user to enter a Vendor Name and Store Number.  The Order Cases button is selected.  An Order form loads.  The user starts entering data for the order.  I need for all orders with this same Vendor Name and store number to appear in
another subform of the form.  

How can this be done in Access 2007?  Please see my database.  I have set up database where the person signed in will only see their orders they put in and not someone elses.

I will have six users entering data into the  system.

Question by:jjc9809
    LVL 39

    Expert Comment

    1. If you have many users and all are entering data, start from splittind DB (all data tables in backend DB and all other objects - in Front end DB). Each user had to have own copy of front-end and can have own Vendor name and Store number.
    2. You can use Forms![Initual Order form]![Vendor] (any field on other form could be set to =Forms![Initual Order form]![Vendor]) almost everywhere, but only in splitted DB.

    Author Comment


    We will only have six users entering data in.  The entering of data will be done by these six users only, so having a Front-end and Backend DB I feel will not be needed.  The entering of data will only be for one day at a Trade Show.  So all orders taken that day by all six users should be OK.   This database will not be used again until next year when we will have the trade show again.

    LVL 39

    Accepted Solution

    I don't see where Vendor is in any orders table. Where it is used? Add vendor and store to recordsource query of your form and it should work, but use unbound fields on your first form (Initual Order Form)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    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…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    737 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

    19 Experts available now in Live!

    Get 1:1 Help Now