Blank Queries

[kabir_hussein]

Hi I have a query where i search for data based on user names. I am trying to make my query show a message when there is no data from the query.

As this is affecting my form by loading a blank form therefore my EXIT button does not appear and i can not exit the form

Hope this makes sense

 

[FoFa]

Well, sounds more like a design issue to me. But bar that, you could run a count query BEFORE you open your form, and NOT open it if that returns zero.

 

[roelandkim]

Have you tried putting your buttons in the form header instead of the main body of the form? That way even if no data is pulled, the user can access any controls. When in a form just go to View -> Form Header/Footer.

 

[kabir_hussein]

Hi job done thanks totally forgot this as i have been for the last few years not using the form header and simply using the form