Fields Won't Display in Form View

[lacey]

Hello,

I have created a database to track our contacts for the office. I spent some time working on the relationships and making sure everything was normalized, as I've only just recently understood that concept. However, I'm afraid something got messed up in the process and I may have missed a step or done something wrong when creating the relationships.

Basically, I just created the form with all of my fields in it and when I try to view the form I see that no fields display (it's just a blank white screen). Does anyone know why this is happening? I only have a few minutes left before my shift is over today so I'm out of time to investigate for today, but I wondered if I should actually be creating the form based off tblcontact, and then add subforms for each of the other tables.

Any ideas or advice is SO appreciated. Getting ready to transition jobs so I need to get this project wrapped up asap. See my attached database for further reference or let me know if I can clarify anything.

Thanks so much!

View attachment Contacts.accdb

 

[Mihail]

No problem to create the form.
Technique:
1) Select, in the Navigation Pane, the table tblContact
2) Go to "Create" in the menu bar.
3) Hit the "Multiple Items" button ("Forms" section of the ribbon)
4) Tweak the form that Access just created for you.

I tweak a little bit the Relationships window.
A simple "rule" : ONE to the left, MANY to the right

Good luck !

 

[missinglinq]

Controls don't appear in Form View when three conditions exist at the same time:

• The Form is Bound to a Table or Query
• There are No Records in the underlying Recordset or the Recordset cannot be accessed
• The Form cannot have New Records added (i.e. is Read-Only)

The reasons that a Bound Form cannot have New Records added include:

1. The File's Read-Only Property has been set to Yes (has been ticked)
2. AllowAdditions for the Form is set to No
3. The underlying Query the Form is based on is Read Only
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/2010) 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.

From the description of problem, I suspect it is likely that #3 above is your problem. Multi-table Queries, needed to have a Form with Fields from more than one Table, are frequently Read-Only.

...I wondered if I should actually be creating the form based off tblcontact, and then add subforms for each of the other tables...

Always the best policy!

Linq ;0)>

 

[lacey]

Alrighty, thanks so much for the help, Linq! I've got a good start so far and have gotten parts of the form to work. I wondered if you could take a look and tell me what I am doing wrong now. It seems the website/products/# of employees fields, as well as all of the check boxes, are not wanting to display still. Any ideas?

View attachment Contacts Example.accdb

 

[The_Doc_Man]

Another little "gotcha" comes about if the properties of the control include "Visible=No" or have something odd in the "DisplayWhen" property for the individual control.

 

[lacey]

All of my form fields visibility property is set to "Yes," so I don't think that's the issue.

Any other ideas?

 

[missinglinq]

I suspect that the problem is that you've really got more Tables than you need, unnecessarily complicating things, and because of this have got your relationships muddled. Your Tables and Fields (ID Fields aren't listed) are

1. tblCompany: CompanyName, Title
2. tblCompanyCategory: (nothing but ID Fields)
3. tblCompanyDetails: Website, Products, # of Employees

Tables #1 and #2 should be in a single Table, along with the # of Employees Field. Unless you will have multiple websites for a given company, the Website Field can go with that, too. What you do with the Products Field depends; if a company has multiple products, best practice is to not list them all in a single Field, but to have a Record for each one, which would require a separate Products Table. If a company only has one type of product, or if you want all products for a given company in a single field, then that Field can go into the same Table with #1 and #2. If you take that route, be absolutely sure that you'll never need to manipulate that data, in any way, such as searching for all companies that produce digital widgets, etc. If you will ever do this, it's better to have any separate Table for Products.

I'd like to help you more with this, but this is an industry I know nothing about, and hence don't understand your business needs, and you've got 8-10 Tables, with very complicated, possibly unnecessarily complicated relationships.

I think you need to take a breath, sit back, and reconsider your data scheme. In any relational database it all begins with the data!

Linq ;0)>

 

[lacey]

Wonderful, wonderful! You were so right about how badly I needed to take a breath and relax. I guess this newbie went a little nuts wanting everything to be perfectly organized that I over-complicated things.


I changed a few things with my tables based on your suggestions and all areas relating to contact and company info are working on the form. However, I am still running into an issue when I try to enter a record and use the checkboxes on the form for "Type of Business," "Relationship to BICS," and "Industry Classification." I get the following error when I click any of the check boxes in either of the three sections:


"The current field must match the join key '?' in the table that serves as the 'one' side of one-to-many relationship. Enter a record in the 'one' side table with the desired key value, and then make the entry with the desired join key in the 'many-only' table."


I'll see if I can figure anything out, but if you have an answer I'd love to hear it.

Thanks again for your help.

 

[lacey]

I am really stuck on this. It seems like a simple fix but I am getting nowhere. I can't make that message make sense to me and I can't find any help by doing an internet search or from searching these forums. Any suggestions anyone has is appreciated!