Drop-Down Select Vendor to Populate Vendor Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dh1069 - 03 May 2007 20:24 GMT

How do I populate my vendor form after selecting a vendor from a dropdown
combo box vendor list within the form? The dropdown combo box wizard doesnt
give me the "Option to Find a Record", when setting up the combo box, so I
need the code. Using Access 2007. Thanks.

Reply to this Message

Maurice - 03 May 2007 21:18 GMT

I dont quite get it... Do you want to go to a specific record an fill that
record or do you want to select a vendor from the list and continu filling
the record?

Maurice

> How do I populate my vendor form after selecting a vendor from a dropdown
> combo box vendor list within the form? The dropdown combo box wizard doesnt
> give me the "Option to Find a Record", when setting up the combo box, so I
> need the code. Using Access 2007. Thanks.

Reply to this Message

dh1069 - 03 May 2007 21:36 GMT

I want to go to the specific record(vendor I select) and then edit the record.

> I dont quite get it... Do you want to go to a specific record an fill that
> record or do you want to select a vendor from the list and continu filling
[quoted text clipped - 6 lines]
> > give me the "Option to Find a Record", when setting up the combo box, so I
> > need the code. Using Access 2007. Thanks.

Reply to this Message

Maurice - 03 May 2007 21:53 GMT

Ok in that case try the following. Place a combobox on the form and choose
the third option from the wizard window. Specify the field you want to use as
the criteria and after that the combo will direct you to that record.

(Make sure the wizard is activated = orange in 2007)

Maurice

> I want to go to the specific record(vendor I select) and then edit the record.
>
[quoted text clipped - 8 lines]
> > > give me the "Option to Find a Record", when setting up the combo box, so I
> > > need the code. Using Access 2007. Thanks.

Reply to this Message

dh1069 - 03 May 2007 22:09 GMT

The wizard works but it only sets up the dropdown combo box list. When I
select a vendor, the form doesnt filter out that record from all the vendors
in my table.

Here are the steps I have in setting up the combo box using the wizard.
1. Look up Value from table or query / Or type the value.
2. Select the Table, Query, or Both
3. Select Fields
4. Select Sort Order
5. Adjust Column Size
6. Remember Value for later use / or save value in this field.
7. Name the ComboBox

That's it.

So my form isn't updated with the information that pertains to the vendor I
have selected from the drop down.

> Ok in that case try the following. Place a combobox on the form and choose
> the third option from the wizard window. Specify the field you want to use as
[quoted text clipped - 16 lines]
> > > > give me the "Option to Find a Record", when setting up the combo box, so I
> > > > need the code. Using Access 2007. Thanks.

Reply to this Message

Maurice - 03 May 2007 22:17 GMT

Ok, I reviewed your steps..

You've chosen the first option from the wizard. Choose the third one. That
should do the trick.

Maurice

> The wizard works but it only sets up the dropdown combo box list. When I
> select a vendor, the form doesnt filter out that record from all the vendors
[quoted text clipped - 34 lines]
> > > > > give me the "Option to Find a Record", when setting up the combo box, so I
> > > > > need the code. Using Access 2007. Thanks.

Reply to this Message

dh1069 - 03 May 2007 22:37 GMT

Maurice,

I don't have any options other than what I typed for steps 1-7. What is
option #3? I have seen it in answers within this discussion group, but the
wizard goes directly to step 1.

> Ok, I reviewed your steps..
>
[quoted text clipped - 41 lines]
> > > > > > give me the "Option to Find a Record", when setting up the combo box, so I
> > > > > > need the code. Using Access 2007. Thanks.

Reply to this Message

dh1069 - 03 May 2007 22:58 GMT

When the wizard asks how you want to get the values for the control, do one
of the following:
1. If you want to display the current data from a record source, click I
want the list box/combo box to look up the values in a table or query.
2. If you want to display a fixed list of values that will seldom change,
click I will type in the values that I want.
3. If you want the control to perform a find operation, rather than serve
as a data entry tool, click Find a record on my form based on the value I
selected in my list box/combo box. This creates an unbound control with an
embedded macro that performs a find operation based on the value the user
enters.

Maurice I found the following in the Access Help Section. I see what you are
talking about now in regards to selecting option 3. However, I do not get
this choice, only choices 1 and 2. How can I get option 3 to show up?

Thanks,

Reply to this Message

dh1069 - 03 May 2007 23:09 GMT

Maurice, for future reference.

I found out by asking a wizards question that you do not get option 3 if the
form is a bound form. Apparently it needs to be unbound. I made that change
by not using an sql for my source and changing it to the vendor table for my
source. Then, upon using the combo box wizard, I had option 3 available.

Thanks for your assistance. I can understand how difficult it can be to try
to assist us novices when we do not provide you with all the necessary
information.

Thanks again.

Reply to this Message

Maurice - 04 May 2007 09:18 GMT

No problem, glad to help. It is strange though because you can make a combo
that way using a bound form. I don't know why you don't see the third option
when the wizard starts. I'll look into it some more for future refs..

Keep playing and learning. Your persistance intrigues me, good job!

Maurice

> Maurice, for future reference.
>
[quoted text clipped - 54 lines]
> > > > > > > give me the "Option to Find a Record", when setting up the combo box, so I
> > > > > > > need the code. Using Access 2007. Thanks.

Reply to this Message