Hi,
I have a form with a subform that is linked on [invoicenumber]. When I load the subform [sfrmBagDescription-Sales] and use the various controls it works fine. When I load it in the main form I get parameter issues. I tried defining the parameters but still have problems. I'm attaching the stripped down version of the database here. When it loads, if you pick a bag name from the drop down list, you will get the first parameter prompt. Each of the dropdown lists following bag name is filtered based on bag name.
Thanks,
Leesah
Parameter issues
-
Leesha
- BronzeLounger
- Posts: 1490
- Joined: 05 Feb 2010, 22:25
Parameter issues
You do not have the required permissions to view the files attached to this post.
-
HansV
- Administrator
- Posts: 78620
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Parameter issues
A subform is not part of the Forms collection, only main forms are. Replace all occurrences of
forms![sfrmbagDescription-Sales]
in the row source of combo boxes on the subform with
Forms!frmLandSales![sfrmbagDescription-Sales]
By the way, I would use the numeric IDs of style, material and color in the inventory table, and of bagname, style, material and color in the landsale items table instead of their text descriptions, but that would require you to redesign both tables and forms.
forms![sfrmbagDescription-Sales]
in the row source of combo boxes on the subform with
Forms!frmLandSales![sfrmbagDescription-Sales]
By the way, I would use the numeric IDs of style, material and color in the inventory table, and of bagname, style, material and color in the landsale items table instead of their text descriptions, but that would require you to redesign both tables and forms.
Best wishes,
Hans
Hans