Hi pplz.
I have 2 forms:
- MainMenu
- Claim
I have a button MainMenu that goes opens up Form Claim at ="[ClaimNumber]="&[ClaimCombo] Where ClaimCombo is a dropdown box on my MainMenu form.
This all works well except after i get to the Claim Form i cant go to next record or last record as it is FILTERED...
So now i have macros: Open form "Claim" and then Search Form Claim for "[ClaimNumber]="&[ClaimCombo]... which is a bit silly as it flickers coz it opens up Claim Form at (eg) Claim 1401 but then as Combobox is 1409 it flickers from 1401 to 1409 fast...
Any ideas?
I also tried open form and filter to selected Claim and then remove filters but of course it jumps back to the first damn Claim again!!!
Please help