Form comes out blank with no fields to enter data

  • Thread starter Thread starter Teddy
  • Start date Start date
T

Teddy

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

I choose the tables and fields I want on my form, columnar layout, and
standard style but when I finish 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
 
On Sun, 10 Jan 2010 08:26:02 -0800, Teddy

This is usually due to an illogical combination of form properties.
For eample if you set AllowAdditions=False and DataEntry=True.

-Tom.
Microsoft Access MVP
 
Teddy said:
When I try to create a form using the form wizard with the fields below
ExpenseCategory
ExpenseItem
ExpenseDate
Projected Cost
Actual Cost

I choose the tables and fields I want on my form, columnar layout, and
standard style but when I finish 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
Click to expand...

Queries based on multiple tables are seldom updateable. That would
eliminate the "new record" row where your form would display all controls
with no data in them.

If you also have a situation where your form does not display existing
records then you get a completely blank detail section. Lak of existing
records could be from the form (filter applied with no matching results or
DataEntry mode) or it could be because the query outputs no rows (could be
from inner joins or WHERE clause matching no records).
 
Back
Top