Form dependent on Query

[stroll]

Hi,

I have a form which uses as its record source a query. This form displays which vehicles are currently signed out. When no vehicles are signed out, my form is blank. i.e. No labels, or buttons appear. They appear again when at least one vehicle is signed out. Does this problem have to do with the query returning no vehicles?

Thanks
Ryan

 

[DougP]

Yes.
Thats a quirk of Access.
How to fix it.
Well if your form is based on the table instead of the query then you could apply a filter that only shows which cars are in out out.

Or sort the recordsource by the column that has them In or Out so all of the one that are In or Out would be at the top.


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.

 

[stroll]

Thanks for your help

Ryan