The form comes out blank with no fields to enter data

[Teddy]

SOLVED:The form comes out blank with no fields to enter data

When I try to create the form using the form wizard with the fields below
ExpenseCategory
ExpenseItem
ExpenseDate
Projected Cost
Actual Cost

The form comes out blank with no fields to enter data. Do you know why this might be happening?

These are my tables

TblExpenseCategory
ExpenseCategoryID
ExpenseCategory

TblExpenseItem
ExpenseItemID
ExpenseCategoryID
ExpenseItem

TblExpense
ExpenseID
ExpenseDate
Comments

TblExpenseDetail
ExpenseDetailID
ExpenseID
ExpenseItemID
Projected Cost
Actual Cost


These are my relationships

ExpenseCategoryID to ExpenseCategoryID

ExpenseCategoryID to ExpenseID

ExpenseID to ExpenseID

 

[Zigzag]

Check the data source for your form, thats usualy where the problem is.

 

[Teddy]

Sorry to bother you, but besides looking at the tables and form in design view again and then recreating the form as I have tried a dozen times, I am not sure how else to check the data source from my form? Any thoughts?

 

[pilsdumps]

This problem is often caused by the record sources not being updatable.
Have a look here:
http://allenbrowne.com/casu-20.html

 

[Teddy]

Got it. Thank you for the tip. I appreciate your help very much.

 

[arichins]

I struggled for 2 hours with this problem today. The problem turned out to be that I forgot to set a primary key on my datatable. If the table is not updatable, Access won't display any of the bound controls if you have the form in data entry mode.

 

[missinglinq]

A Table is always updatable! But Queries based on multiple tables sometimes are and sometimes aren't, as are Forms based on these Queries..

 

[arichins]

The source of my form was a SQL Server table, and I have never been able to update a sql server table through Access, or another external program if the table doesn't have a primary key. It's technically against relational database design to have two identical rows. Perhaps there's a setting in SQL Server that is enforcing that, and Access is detecting that the table is thus "not updatable"

Also, it's possible that the table would not be updatable due to a permission issue.