Access Help

rctneil · 6 Mar 2010 at 16:36

Hey,

I ahve made a database containing two tables in Access and they are linked with a 1 to M relationship. I ahve made a form from one of the tables and on the form is a box where the user enters the id of the company associate with that product. Instead of the user having to find the id and then enter it into the text box. How can I get a combo box to appear and it auto fill with the names of all the companies from the companys table and when the form is submitted then the correct id appear in it's place?

rctneil · 6 Mar 2010 at 17:06

I'm trying all sorts to no avail here. Whats confusing me, is how I get the combo box to dynamically display all the names of the companies in the box but when one is chosen then the associated id of that company is used when inserting into the table?

rctneil · 6 Mar 2010 at 17:43

Right, I started that but no wizard is appearing when i draw the box on the form?

rctneil · 6 Mar 2010 at 17:46

i'm using 2010 beta but it's not terribly different from 2007

rctneil · 6 Mar 2010 at 17:53

Found that option. It's in a drop down below the controls now!

Just following your steps now, will post back!

rctneil · 6 Mar 2010 at 18:09

Excellent, Thanks so much. My form is sooo much easier to use now!

I will have some other access questions as I get further on with creating this mini system

rctneil · 6 Mar 2010 at 18:17

ok, another question for you:

I have made a form being used as a main menu sort of thing. I have added a button to open a form and it works and does open the form. How can I make the button open the form but open it so the form is blank ready for a new entry to be added?

I also wish to add another button to open the form but to just open it to any records page so the user can just use navigation buttons to browse throguh the records one by one

Bonus Question. This system is aiming to be a simple system for me to be able to organsise any receipts from orders I do as I currently don;t have a way to keep track of them. I don;t need anything fancy but a system like this will enable me to get what I want and also for me to learn a bit about using Access to build a database application:

Right, If I am on the "Add Receipt" form whcih I ahve already built and I fill in all the details and go to choose the company from the drop down list but the company I want does not yet exist. What is the best way of adding it without losing the data already entered or how can I create a new company and associated fields on the same "add receipt" form or open the "add comapny" form, fill in the details of that and then choose the newly added company from the dropdown in the receipt form?