I have an "after update" event that checks the option chosen in a pop-up form
with the information in a field on the main form. If the department is wrong
it brings up a message. If it is correct it would then set focus on the next
textbox.

hola..
i have make a query for a table in my database..but..i need to add
field from another table to that query..can i???can anyone help me???

I have a form with 2 subforms. The current record in subform1 determines the
filter applied to subform2. However, if I can't get subform2 to display
filtered data when the main form loads, because the statement
   Me.Parent.subfrmKitComps.Form.Filter = "KitItem = '" & ...