Hi,
Currently i have a form with multiple pages in that links to seperate fields/tables etcetc, i have a couple of combo boxes that link to each other ie. in Rowsource
SELECT Distinct [Field1] FROM [TBL1] WHERE [Field2] = [forms]![FRM1].[Combo1]
The problem is that when filtering the options are no longre avaliable? the links cease to function! why? and is there a fix? or another idea i had is to reate another page in the form purely for filtering if so, is there a way that as soon as i click on the page tab it will automatically go into filter by form mode?
Thx
Currently i have a form with multiple pages in that links to seperate fields/tables etcetc, i have a couple of combo boxes that link to each other ie. in Rowsource
SELECT Distinct [Field1] FROM [TBL1] WHERE [Field2] = [forms]![FRM1].[Combo1]
The problem is that when filtering the options are no longre avaliable? the links cease to function! why? and is there a fix? or another idea i had is to reate another page in the form purely for filtering if so, is there a way that as soon as i click on the page tab it will automatically go into filter by form mode?
Thx
