"lyle fairfield" <lyle.fairfield@[EMAIL PROTECTED]
> wrote in message
news:4cb9973c-e458-4260-9044-34400276a8f4@[EMAIL PROTECTED]
think, Arvin, the form controls will show, but be blank. Probably
this is what you mean. In any case, the form can be viewed,
that is, it will be visible. My interpretation of the OP is that the
form or forms cannot be viewed except in design mode,
I tested this with Access 2007, The North-wind sample, a form with a
record-source of
===========================
Hi Lyle,
Actually, in Access 2003 and earlier, controls on a bound form which has
no
data and is not updateable will not show, neither will their associated
labels. AAMOF, nothing on the form's detail section shows, including
command
buttons, etc. I haven't tested this yet in A 2007, but will sometime today
and let you know. This is what I used from Northwind:
Select SupplierID, CompanyName
From Suppliers
Group By SupplierID, CompanyName
Having 1=2;
Using an aggregate guaranteed no records and that the query would not be
updateable. Your query was not updateable, but it did return 1 blank
record.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
|
