combo box on subform

[char]

I have created a 'Lessons Learnt' database,
I have a table with many fields for example, project name, category, discipline, phase, description etc
I have a form which is called [Discipline], this shows all the fields in a multiple items webform. I have inserted a combo box which filters the form, so if I select Track in the combo box the lessons relating to the track discipline appear. This works perfectly:



Set Filter Where Condition = [Discipline]=[Forms]![Discipline]![combo39]
Requery

When I then add this form to my navigation form, it no longer works. I receive an error message about defining my parameter. Could anyone help me solve this problem?
I am creating my database in the web version of Access so using Macro.

Thanks

[June7]

Seems to be a common issue posted in form but don't find many references with a solution. Probably need to reference combobox through the navigation control.

Review:
https://www.accessforums.net/forms/h...cts-21613.html
http://www.access-programmers.co.uk/....php?p=1086079

[char]

Thanks for the response!
I have tried removing the form name and replacing it with navigationsubform.. but it still brings up the same error saying I have no defined parameter.
When I select OK to the first error, a box appears which is like when you create a query that prompts for input.

I am doing an After update Macro..
SetFilter Where Condition= [Discipline] = [Forms]![NavigationSubform]![combo39]
Requery

I also tried:
SetFiler Where Condition= [Forms]![NavigationSubform]![Discipline] = [Forms]![NavigationSubform]![Combo39]

Any suggestions on where I might be going wrong would be appreciated!

[June7]

I never used a navigation form. I use tab control with subforms on the tab control pages. I also don't use macros, only VBA. I know web database preempts VBA, not sure about tab control. Yours is not the first thread I've worked with on this issue. Review this one https://www.accessforums.net/forms/n...ers-28983.html.

[char]

I have had a look at that link, the Apply Filter solution he used is not applicable with the web as that macro does not appear in the list of usable macros.
If I kept it as its own form and didn't drop it into the navigation form it complicates other issues as I cannot open the form as a normal window I have to open it as a dialog window (web access only allows forms to be opened by command buttons in this format).

If anyone has anyone has any other suggestions please let me know. Thanks