Form Not showing when adding fields from more than one table

[quelikyn]

I have a Hardware Inventory form that has entry fields for various types of hardware that reside in the Hardware table. The fields all work fine until I add in a Printer field from the Printer table or a Server field from the Server table. When I add either of these two fields then when you open the form for data entry the form is blank. When you open the form in Design View then all the fields are visible.

I also have a Printer form that draws from the Printer table that works fine and a Server form that draws from the Server table that works fine. It is only when I add the Printer field/Server field to the Hardware Inventory form that I have this issue.



Any help would be appreciated.

[Missinglinq]

Controls don't appear in Form View when three conditions exist at the same time...conditions that make a Form Read-Only:

The reasons that a Bound Form is Read-Only...i.e. cannot have New Records added or existing Records edited include:

1. The File's Read-Only Property (in Windows Explorer) has been set to Yes
2. AllowAdditions/AllowEdits for the Form is set to No
3. The underlying Query the Form is based on is Read Only (Note that all Forms based on Fields from multiple Tables are, in essence, based on Queries)
4. User doesn't have Read and/or Write Permission for the Folder where the Data resides or there is a connection problem with the network.
5. Folder the File resides in (in versions 2007 or later) not having been declared as 'Trusted'
6. Form's Recordset Type is set to Snapshot
7. All Controls on the Form being Locked or Locked and Disabled.

Linq ;0)>

[June7]

General rule for data entry is "one table per form". Lookup tables can be included in form RecordSource in order to display related info but only one table can be the target for data entry/edit.

Why are you including the additional tables in form RecordSource?

Post the query SQL statement.

If you want to provide db for analysis, follow instructions at bottom of my post.

[John_G]

when you open the form for data entry the form is blank.

What do you mean by "blank" in this context? Is the form showing no fields (controls) at all (just an empty screen, essentially), or are the fields there but with no data?
These are actually two quite different scenarios.

...until I add in a Printer field from the Printer table

Not sure what you mean by that. You can't add a control from another table unless that table is part of the form's recordsource query. Can you clarity what you did there?

To add to one of Linq's notes above:

A form will not show any controls (i.e. is blank) if:

AllowAdditions (snipped) for the Form is set to No AND the form's recordsource query selects no records.
(red text is mine)

I suspect this may be your issue - we just have to find out why.