Display Records

[Legends77]

I have a form (frmvendorshow) with the following fields: vendorname / SAPNumber / Active

What I need is to make vendorname a drop down box and once the vedor is selected, the correct SAPNumber and Active to appear.

Currently, I keep changing only vendor name and all else stays the same. I know this is rather basic but am having trouble.

thanks in advance for any help

 

[missinglinq]

Here's a quick tutorial I give people for this:

If you haven't already done so, create a form based on your table or query, including all the fields you want displayed. Then simply:

Add a combo box to your form.

The Combobox Wizard will pop up

Select "Find a record based on the value I selected in my combobox."

From the table or query the form is based on, click on the field you're searching by (vendorname in your case) to move it to the right side.

Hit Next.

Size the column appropriately.

Hit Next.

Name the combobox.

Hit Finish.

Now you can drop the combobox down and scroll down to the vendorname to search by, or you can start to enter the vendorname, and the combobox will "autofill" as you type. Hit <Enter> and the record will be retrieved.


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[Legends77]

Worked great, thanks!

 

[missinglinq]

Glad we could help!

Linq ;0)>

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!