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 will not display records
In Access 2007, one of our users has asked me to research the following,
She built one form, using fields from 5 tables, each table has a field, Item_ID, it is the Primary key in all 5 tables, and a 1-1 inner join relates the 5 tables. She then created the form, using the fields from the tables. Data entry works perfectly, and the tables get populated, but when closing the application and then restarting it, the data does not display in the form, although it is still in the tables. What could cause this behavior? |
#2
|
|||
|
|||
Form will not display records
What is the SQL feeding the form?
-- Build a little, test a little. "PA" wrote: In Access 2007, one of our users has asked me to research the following, She built one form, using fields from 5 tables, each table has a field, Item_ID, it is the Primary key in all 5 tables, and a 1-1 inner join relates the 5 tables. She then created the form, using the fields from the tables. Data entry works perfectly, and the tables get populated, but when closing the application and then restarting it, the data does not display in the form, although it is still in the tables. What could cause this behavior? |
#3
|
|||
|
|||
Form will not display records
If the Data Entry Property of the form is set to Yes, this is the expected
behavior.This setting only allows new records to be entered,. It does not allow existing records to be displayed. Despite its name, Data Entry does not have to be set to Yes in order to enter records. AllowAdditions and AllowEdits set to Yes will allow new records and existing records to be seen, as well. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
Form will not display records
Thanks for the reply - but Data Entry is set to No.
Any other thoughts will be greatly appreciated. "Linq Adams via AccessMonster.com" wrote: If the Data Entry Property of the form is set to Yes, this is the expected behavior.This setting only allows new records to be entered,. It does not allow existing records to be displayed. Despite its name, Data Entry does not have to be set to Yes in order to enter records. AllowAdditions and AllowEdits set to Yes will allow new records and existing records to be seen, as well. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com . |
#5
|
|||
|
|||
Form will not display records
"PA" wrote in message
news In Access 2007, one of our users has asked me to research the following, She built one form, using fields from 5 tables, each table has a field, Item_ID, it is the Primary key in all 5 tables, and a 1-1 inner join relates the 5 tables. She then created the form, using the fields from the tables. Data entry works perfectly, and the tables get populated, but when closing the application and then restarting it, the data does not display in the form, although it is still in the tables. What could cause this behavior? If her form's recordsource query performs an INNER JOIN among five tables, every one of those tables must have a matching record in order for the query to return any data. That means that at least one field from every table must have something entered in it. Does that happen? It's likely that the query should not be using inner joins, even if the tables have one-to-one relationships. -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|