K
K
Good day, I am trying to sort a subform based on a combo Box afterUpdate Event.
Details......
Main Form Name = frmSearch (Combo Box Name = ComboAlloy)
Subform Name =SubfrmSearch (Underlying Query Name = qrySearch
Macro Name = Filters:Alloy
Apply FIlter = qrySearch
Where Condition
[tblQuoteHeaderSub.AlloyType]=[Forms]![frmSearch]![ComboAlloy]
However it isnt working..Can someone help me with this. Not sure what I am
doing wrong. I get Action Faoled and a message "The action or Method is
invaild because the form or reports isnt bound to a table or query"....
Any help would be appreciated.
Thanks, Kyle.
Details......
Main Form Name = frmSearch (Combo Box Name = ComboAlloy)
Subform Name =SubfrmSearch (Underlying Query Name = qrySearch
Macro Name = Filters:Alloy
Apply FIlter = qrySearch
Where Condition
[tblQuoteHeaderSub.AlloyType]=[Forms]![frmSearch]![ComboAlloy]
However it isnt working..Can someone help me with this. Not sure what I am
doing wrong. I get Action Faoled and a message "The action or Method is
invaild because the form or reports isnt bound to a table or query"....
Any help would be appreciated.
Thanks, Kyle.