Queries - Disable a form behind an open query!!!!

Hi, I have a form which has a button on it. The button simply opens a query. How can I make the form become disabled or locked so that when the query is open in front of the form the user cannot click back onto the form (which is behind the query) Thus the only way for the user to return to the form is to close the query first! - Thanks Regards Grahame

I would not allow users to have direct access to a query since you cannot control the way your user's access to a query; they will have full access to the data and changing them without your permission. I would, instead, create a form based on the query. With a form, you have better control of the way your users access it. If you want this form to stay on top of the previsous form and not allow the user to use the control in the previous form until the new form is closed, you simply set the form property for "pop-up" to yes and "model" to yes

Good Point, I understand exactly! Thanks for the warning