[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Access 2007 Question

Posted on 2012-08-14
Medium Priority
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
  • 2
LVL 40

Expert Comment

ID: 38294890
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

ID: 38296704

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 40

Accepted Solution

als315 earned 2000 total points
ID: 38297577
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)

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

872 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