I have a lookup field in a query that functions correctly. When the same query and field are used in a form the look up fails to function. Coding for a me.form.requery does nothing. Suggestions?