If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form comes out blank with no fields to enter data
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 |
#2
|
|||
|
|||
Form comes out blank with no fields to enter data
On Sun, 10 Jan 2010 08:26:02 -0800, Teddy
wrote: 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 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 |
#3
|
|||
|
|||
Form comes out blank with no fields to enter data
Teddy wrote:
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 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). |
Thread Tools | |
Display Modes | |
|
|