D
Dave Harding
Guest
Hi all,
I work in a CAD software application support group, and we’re trying to keep track of which CAD systems our company’s suppliers have and which file formats they prefer to receive. We built a modest MS Access 2000 Supplier db and created data entry forms.
One of the forms we still need to build is a tabular form for entering preferred file formats. Any given supplier may choose to receive one or more file formats. Any given file format may have 1 or more types or “flavors”. Accordingly, we have a
“3D Format” table with Format ID and Format Name and a
“Format Type” table with Format Type ID, Format Type Name and Format ID (foreign key to the Format Type table).
The form should allow the user to choose a 3D Format, then populate the Format Type combo box with only those types particular to the chosen 3D Format.
I created a form using synchronized combo boxes based on a MS Webcast named “Combo Box Survival Guide” at support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc080300/wcblurb080300.asp. There is a Powerpoint download that showed exactly what I needed to do, so I applied it to my situation, and it worked perfectly!
The Format Type combo box’s row source is a query based on the Format Type table that filters on the value of the 3D Format combo box. A macro refreshes the content of the Format Type combo box on the AfterUpdate event of the 3D Format combo box.
The problem comes when I make the perfectly work form a subform of the main Supplier form. Then, when I select a 3D Format, I get an error pop-up with lots of verbiage:
“You can’t use the ApplyFilter action on this window.
…
You may have applied the filter to a form, but the form wasn’t open in Form or Datasheet view.
…
Use the SelectObject action or method to select the table, query, form, or report before applying the filter.”
Then, when I click OK, an Action Failed window referencing the macro pops up.
I tried a couple of things that didn’t work.
1) I tried the SelectObject action.
2) I tried qualifying the form that contains the combo boxes as a subform in the query.
The original query referenced “[Forms]![f 3D Formats and Types]![3D Formats]”
I changed this to “[Forms]![f Supplier]![f 3D Formats and Types].[Form]![3D Formats]”, but continued to receive the same error message.
I have tried this where the main form is the real Supplier form and the subform date is linked to the Supplier table. To remove doubts about whether the problem had to do with form or table linkages, I made my form a subform of a completely brand new, blank form with no links to any other tables and no other fields or controls of any type other than my subform. The result was the same as above.
What’s left to try here? Thanks for your help.
I work in a CAD software application support group, and we’re trying to keep track of which CAD systems our company’s suppliers have and which file formats they prefer to receive. We built a modest MS Access 2000 Supplier db and created data entry forms.
One of the forms we still need to build is a tabular form for entering preferred file formats. Any given supplier may choose to receive one or more file formats. Any given file format may have 1 or more types or “flavors”. Accordingly, we have a
“3D Format” table with Format ID and Format Name and a
“Format Type” table with Format Type ID, Format Type Name and Format ID (foreign key to the Format Type table).
The form should allow the user to choose a 3D Format, then populate the Format Type combo box with only those types particular to the chosen 3D Format.
I created a form using synchronized combo boxes based on a MS Webcast named “Combo Box Survival Guide” at support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc080300/wcblurb080300.asp. There is a Powerpoint download that showed exactly what I needed to do, so I applied it to my situation, and it worked perfectly!
The Format Type combo box’s row source is a query based on the Format Type table that filters on the value of the 3D Format combo box. A macro refreshes the content of the Format Type combo box on the AfterUpdate event of the 3D Format combo box.
The problem comes when I make the perfectly work form a subform of the main Supplier form. Then, when I select a 3D Format, I get an error pop-up with lots of verbiage:
“You can’t use the ApplyFilter action on this window.
…
You may have applied the filter to a form, but the form wasn’t open in Form or Datasheet view.
…
Use the SelectObject action or method to select the table, query, form, or report before applying the filter.”
Then, when I click OK, an Action Failed window referencing the macro pops up.
I tried a couple of things that didn’t work.
1) I tried the SelectObject action.
2) I tried qualifying the form that contains the combo boxes as a subform in the query.
The original query referenced “[Forms]![f 3D Formats and Types]![3D Formats]”
I changed this to “[Forms]![f Supplier]![f 3D Formats and Types].[Form]![3D Formats]”, but continued to receive the same error message.
I have tried this where the main form is the real Supplier form and the subform date is linked to the Supplier table. To remove doubts about whether the problem had to do with form or table linkages, I made my form a subform of a completely brand new, blank form with no links to any other tables and no other fields or controls of any type other than my subform. The result was the same as above.
What’s left to try here? Thanks for your help.
