Electric Ant
New member
- Local time
- Today, 18:31
- Joined
- Oct 11, 2004
- Messages
- 7
I've got a problem with the order in which records appear in my form, and I just can't figure out what is wrong. It's probably obvious but I've been staring at it for too long now.
I have a Parent form with several child forms on different pages. I've got a module to create records that appear in the child forms that are linked to the parent form and you would probably have 2 to 4 records in each child form for each record in the parent form. I've set the child forms up as continous forms so you can see all records in the child form on the screen in one go.
Sometimes when you tab to the next page (ie. the next child form) the order in which the records appear changes, which is very annoying for the person doing the data entry and could lead to input errors if you don't notice.
It only happened in one record and the others seem ok. To try to resolve this I sorted the unlying tables, sorted the queries used to pull out data for the form and put in Order by in each child form. However, still had the same problem with this one particualr record. In the end I deleted this records and started it again and the order was then the same throughout.
Has anyone come across this before and have any suggestions of how to prevent it happening. Very grateful for any suggestions.
Thank you
I have a Parent form with several child forms on different pages. I've got a module to create records that appear in the child forms that are linked to the parent form and you would probably have 2 to 4 records in each child form for each record in the parent form. I've set the child forms up as continous forms so you can see all records in the child form on the screen in one go.
Sometimes when you tab to the next page (ie. the next child form) the order in which the records appear changes, which is very annoying for the person doing the data entry and could lead to input errors if you don't notice.
It only happened in one record and the others seem ok. To try to resolve this I sorted the unlying tables, sorted the queries used to pull out data for the form and put in Order by in each child form. However, still had the same problem with this one particualr record. In the end I deleted this records and started it again and the order was then the same throughout.
Has anyone come across this before and have any suggestions of how to prevent it happening. Very grateful for any suggestions.
Thank you
Hello Electric Ant!
