Error

[Kelly H.]

I receive an error when I try to open a subform from a
command button on a main form. I receive a parameter
error. It occured ever since I sorted the subform
alphabetically. Before I sorted the subform, I had no
difficulty opening the subform from the command button on
the main form.

Thank you for your help!!

Kelly H.

 

[John Viescas]

Kelly-

If you sorted a combo box and the display field in the combo box isn't in
the record source of the form, Access saved a filter using a subquery -
which might no longer be valid. Open the subform in design view, open the
Properties window, select the form, clear the Filter property, and save the
form. That should fix it.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)