aphelps
Bird Man
- Local time
- Today, 16:14
- Joined
- Aug 2, 2002
- Messages
- 32
Hi --
I have a data entry form that contains 22 fields from six tables. The same primary key exists in all six tables (NestCode); five of the tables are linked 1:1 with the first (which happens to be tblNestLocation). This form is based on a query (qselMainDataFormQuery). The form also contains two subforms, each a small complete table, and each also linked 1:1 by NestCode to tblNestLocation (except that one of them has a composite key, including both NestCode and VegSpp).
Now, when I open the form and enter data, I get increasing numbers in the record navigation boxes at the bottom of the form. However, if I close the form and reopen it, it returns to 1 of 1 at the bottom, and previously entered records are inacessible.
The information is in the correct tables in the correct place. At first I thought it was a form property problem, but I think it's all good there (Allow edits, deletions, and additions are all yes, data entry is no). A co-worker suggested checking the query upon which the form is based and, when I run it independent of the form, it comes up empty (again, even though the info is in the tables). Therefore, apparently, it's coming up empty when the form tries to run it, thereby leaving me with no accessible records in the form.
I would like to be able to cycle through these records in the form, as this is not "enter-once-and-forget" data, but may need to be updated throughout the breeding season.
I appreciate the help....Adam
I have a data entry form that contains 22 fields from six tables. The same primary key exists in all six tables (NestCode); five of the tables are linked 1:1 with the first (which happens to be tblNestLocation). This form is based on a query (qselMainDataFormQuery). The form also contains two subforms, each a small complete table, and each also linked 1:1 by NestCode to tblNestLocation (except that one of them has a composite key, including both NestCode and VegSpp).
Now, when I open the form and enter data, I get increasing numbers in the record navigation boxes at the bottom of the form. However, if I close the form and reopen it, it returns to 1 of 1 at the bottom, and previously entered records are inacessible.
The information is in the correct tables in the correct place. At first I thought it was a form property problem, but I think it's all good there (Allow edits, deletions, and additions are all yes, data entry is no). A co-worker suggested checking the query upon which the form is based and, when I run it independent of the form, it comes up empty (again, even though the info is in the tables). Therefore, apparently, it's coming up empty when the form tries to run it, thereby leaving me with no accessible records in the form.
I would like to be able to cycle through these records in the form, as this is not "enter-once-and-forget" data, but may need to be updated throughout the breeding season.
I appreciate the help....Adam
