Using MS Access/Linking Fields Problem

Advertisement


Question
Access Form
Access Form  
I work for a company that makes parts for other companies.  We use Access to keep track of the parts each company requests. I am a beginner to intermediate Access user who recently started.

When I put a part number in, the corresponding company automatically shows up.  My superior would like the same result for another field, called Revisions.  How do I link one field to show a result when I type in another field?

I have attached an image of a blank form for reference.  Thank you.

Answer
Hi Ryan,

Thanks for the question.

I need a bit more information to answer your question.  Could you send me an image of the underlying query, that provides the data for this form.

I am presuming the previous developer, set up the query in such a way, that the fields required were automatically populated when the number was added, but I need to see this query to know for sure.  

Also...just to check,
1. Do you want information for Revisions, to come up when the number is entered, or will you be typing something else into another field.
2. On the form, I cannot see Company, is that the same as Customer
3. Where do you type the number, that displays the company information, on this form or on the main menu.

If you could step me through exactly what you want, what fields you are talking about and what tables/queries they come from.  I should be able to help, unfortunately I do not have enough information to assist at the moment.

Regards

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Julie Misson

Expertise

My area of expertise is Microsoft Access 2000-2007. I have been building microsoft databases for the past twelve years. I would be competent in answering questions from novice Access 2000 users to the more advanced including VBA. If I cannot help, I am more than likely be able to point you to websites that can.

Experience

I have a Microsoft Access business where I build database for small businesses. These are usually one off designs, where there is no off the shelf software avaliable to meet the business needs. I also teach Microsft Access to beginners. I am the owner of the www.simply-access.com website.

Education/Credentials
Self taught in Microsoft Access. Have done some units in normalisation and SQL, but most of what I know I have learnt from books originally and more recently the Internet.

©2016 About.com. All rights reserved.