Combo Box > Control Subform > Datasheet

[JK]

I'm trying to add a new feature to my workorder database (2003.) I want to
track Vendor Invoices by Customer. I created a form where I can enter each
Vendor's contact information and a subform for each Vendor to enter the items
we would pay for.

Now, in the workorder screen, I want to give the user the ability to select
a vendor's name in a pull down menu then, have the subform in datasheet view
activate so that only that vendor's items can be selected in multiple other
drop-down menus (product number or product name.)

Any idea how can I make this link? Maybe a point in the right direction or a
different approach? Thx...

 

[Klatuu]

Create a combo box with a query on the Vendor table that returns the vendor's
name and if there is a primary key for you vendor table, that key in another
column.

Then when the user selects a vendor, make it the current record for the main
form. Assuming you used the Link Master fields and Link Child fields in the
subform control's properties, the vendor's items will show up in the sub form.

 

[JK]

Even if the "Subform" is a data entry screen? I want the user to be able to
either enter an item number or pull down a menu to select an item number (but
only items that are assigned to the selected vendor (vendor is selected
outside the subform.))

I don't want to just display the vendors items...

 

[JK]

In the Query for the DropDown boxes in the subform where I would select the
parts, I added supplierID & then made it equal the vendor pull-down menu on
the main form. This did the trick.

You got me thinking and for that, thank you...

Jason