New user help

Hello, I am very new to the Access world, and my boss has assigned me a project. I need to figure out the correct expression to put in this property box. Currently I have 2 fields in a table named Vendor. The fields are named VendorName and Address. Now I have a form named Assets that have an option to Select the VendorName. I want the option under that for his address to automatically change when I select the vendor name. Sorry for the bad explaination, I am very new to this.

So far I have

=IIf((Vendors!VendorID)=(Assets!VendorID),Vendors! Address)

Bump, Anyone? I'm sure im going in the wrong direction. I just need to make it to where when one text box changes the other one displays the address

We ask that you not bump a posting within 24 hours. That won't get you any more help and may irritate some of the people who are most qualified to help you.

Yes, you're going in the wrong direction. Access is a relational database system and you will need to understand what that means. First of all, your Vendor table needs many more fields than you have. It should look more like this:


I assume that you're just beginning your project and haven't yet determined what's going into your Assets table. If so, you're starting on the wrong foot. Having taught database courses in college for more than ten years, I can assure you that you need to design all your tables before doing anything else. Then the design of your forms will be rather simple. Starting with one table and working on a form, when you haven't yet designed the other tables will result in re-doing your forms over and over again.

That said, with a vendor table structured as above, the way you can display on the form the data when you select one of the vendors depends on what else you're going to do with the form. Perhaps the most common way to go about it is to have a combobox on the form, with its Row Source being a Query with 2 columns, only the second of which is shown to the user. The first column would be the vendorID field, the second would be the vendorName field. Then the rest of the controls on the form would be bound to another Query whose Criteria would be the vendorID column of the combobox. In the onChange event of the combobox, you would Refresh the form, thus populating the form with data from that vendor record.

But the real question is, what would you do, once the vendor's data is displayed? You see, you can't design this form until you have designed the logic for the whole system.

This is not something that you're going to do in an hour, or a day, or as a beginner, in a week.

You can check out this tutorial below:

Create a combo using the wizard and then find the record based on the value you've selected in combo

That should get you started