Can't see Body of Form

[Brian Keanie]

Greetings!
Have designed a form with a "form Header", "form footer" and detail in the
centre. In design view I can see all three sections of the form but in form
view I can only see the header and footer and therefore not permitted to
input to fields in the detail section. Could someone enlighten me as to how
to show and input to the detail section in form view.
Access 2000.

Thanks

 

[John Vinson]

Greetings!
Have designed a form with a "form Header", "form footer" and detail in the
centre. In design view I can see all three sections of the form but in form
view I can only see the header and footer and therefore not permitted to
input to fields in the detail section. Could someone enlighten me as to how
to show and input to the detail section in form view.
Access 2000.

Thanks

You may be getting this if the Form is based on a recordset which a)
has no records so you don't see any existing data and b) is not
updateable so you don't see the new record either.

What's the Form's Recordsource property? If you open it as a query
datsheet, does it have any data? and does it have a *> blank record at
the bottom (indicating that it can accept new records)?

If you can't figure out why it might be non-updateable open it in SQL
view and post the SQL text here.

Just one comment which may not apply: starting to design your database
with a Form is like building your house starting with the windows. The
Tables and their relationships need to be set up correctly before you
should even think about forms!

 

[Brian Keanie]

Here is the SQL for the underlying query. The form prints okay and there is
dat in it. Just can't see the body to be able to input data.

Thanks for the assistance.

SELECT DISTINCTROW [Material Master].ItemNo, [Material Master].Desc1,
[Material Master].Desc2, [Material Master].ProdClass, [Vendor
Master].VendNo, [Material Master].PUnit, [Material Master].IUnit, [Material
Master].IPR, [Material Master].OQ, [Material Master].TRC, VendItems.[Vend#],
VendItems.Price, VendItems.Discount, VendItems.ShipVia,
VendItems.HowShipCode, [Vendor Master].VendNo, [Vendor Master].VendName,
[Vendor Master].Address1, [Vendor Master].Address2, [Vendor Master].City,
[Vendor Master].ProvState, [Vendor Master].Zip, [Vendor Master].Country,
[Vendor Master].Phone, [Vendor Master].PayCode, [ShipCode Table].HowShip,
[MaterialMessCode Table].Message, [VendorMessCode Table].Message,
VendItems.[VendsItem#], tblAnnualUse.[2000], tblAnnualUse.[2001],
tblAnnualUse.[2002], tblAnnualUse.[2003]
FROM ((([MaterialMessCode Table] INNER JOIN [Material Master] ON
[MaterialMessCode Table].MessCode = [Material Master].MessCode) INNER JOIN
(VendItems INNER JOIN [ShipCode Table] ON VendItems.HowShipCode = [ShipCode
Table].ShipCode) ON [Material Master].ItemNo = VendItems.[Item#]) INNER JOIN
tblAnnualUse ON [Material Master].ItemNo = tblAnnualUse.ItemNo) INNER JOIN
([VendorMessCode Table] INNER JOIN [Vendor Master] ON [VendorMessCode
Table].MessCode = [Vendor Master].MessCode) ON VendItems.[Vend#] = [Vendor
Master].VendNo
WHERE ((([Material Master].ProdClass)=[Select the Product Class]) AND
(([Vendor Master].VendNo)=[Enter Vendor No]));

 

[John Vinson]

Here is the SQL for the underlying query. The form prints okay and there is
dat in it. Just can't see the body to be able to input data.

You're joining SEVEN TABLES into one monster query and trying to input
data into... what? All seven tables? It is *not* going to work.

I do not know how your tables are related, but I would very strongly
suggest that you use a simpler Form for the "one" side table, with one
or more subforms for the "many" side tables that you want to update;
if you have lookup tables, such as ShipCode, you don't need to include
them in the query at all - just use a Combo Box to store the shipcode
while displaying the HowShip value.

 

[Brian Keanie]

John .... Sorry ... Maybe I wasn't clear as to what I'm trying to achieve.
In this particular form I am not trying to update any tables. I am trying to
put out a "quotation" to a vendor so I pull pertinent info from the tables
and then I want to input info like Quote number, return deadline date,
quantity of item to quote on etc. These "unbound" input fields are not
intended to be updated and are for this one use only. The question remains
""why can't I see the body of the form?""

Thanks again for your responses. I also get ideas from your responses. Best
regards

 

[John Vinson]

John .... Sorry ... Maybe I wasn't clear as to what I'm trying to achieve.
In this particular form I am not trying to update any tables. I am trying to
put out a "quotation" to a vendor so I pull pertinent info from the tables
and then I want to input info like Quote number, return deadline date,
quantity of item to quote on etc. These "unbound" input fields are not
intended to be updated and are for this one use only. The question remains
""why can't I see the body of the form?""

You can't see the body of the Form because

1) It's based on a Query which returns no records and
2) that Query is not updateable.

It sounds like you should be using a completely unbound form, i.e. one
with no Recordsource property at all, to allow the user to input these
fields; and then generate a Report if you'll be sending it to a vendor
as a quote. The Report's textboxes can have control sources like

=Forms!frmQuoteForm!txtDeadlineDate

to pull information directly from the user input.