Parameter to Listbox populated with Sproc (1 Viewer)

[yahazim]

Hello!

I just created an Access .mdb to an .adp because my deployment method just changed today.

I am recreating the RowSource of a Listbox to a Stored Procedure with one input parameter, called @VendorID, based on a field in the main form.

The real world example is that I have a form that represents Vendors, and I am wanting to show the list of Applications related to each Vendor in a non-updateable, information only based Listbox that requeries when the record is changed. Hence the setup in the above paragraph.

OK. So I created the SProc, and set it as the RecordSource. Now I set the InputParameters Property on the main form to:

@VendorID int=[forms]![frmVendor]![VENDOR_ID]

and I get a "Bad query parameter" error.

Help? Please let me know if I am going in the right direction with this, or if I just need to write the full VBA code to do this (which I'll do but I'm wanting to achieve rapid development... ahem).

Thanks in advance!

Jim Meyer
EDS, Inc.

 

[boblarson]

This is kind of out of my normal scope of operations, however I have one quick suggestion that might work (and maybe not).

Instead of:
@VendorID int=[forms]![frmVendor]![VENDOR_ID]

Have you tried:
@VendorID int=[forms]![frmVendor]![VENDOR_ID].Value

BL
??