|
| 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
April 14th, 2008, 05:02 AM
posted to microsoft.public.access.forms
|
|||
|
|||
Subform not showing all records
I have a subform that I enter data to update training files. Once I have
entered the data it can not longer be seen (although it is in the appropriate table). The data is entered after using a cbo to select the correct reference to update. (ie. I select safe work procedure 1 - then enter a training date). I want to see all records accociated with this selection on the datasheet is this possible. Thanks anyone. 
|
|
#2
April 14th, 2008, 07:21 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Subform not showing all records
Sounds like the DATA ENTRY property of the form is set to YES. Set it to NO.
-- Bob Larson Access World Forums Super Moderator Tutorials at http://www.btabdevelopment.com __________________________________ "Try Hard" wrote: I have a subform that I enter data to update training files. Once I have entered the data it can not longer be seen (although it is in the appropriate table). The data is entered after using a cbo to select the correct reference to update. (ie. I select safe work procedure 1 - then enter a training date). I want to see all records accociated with this selection on the datasheet is this possible. Thanks anyone.
|
|
#3
April 14th, 2008, 07:31 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Subform not showing all records
Thanks boblarson, I have checked the DATA ENTRY properties of both the main
and subform they are both set at "NO". "boblarson" wrote: Sounds like the DATA ENTRY property of the form is set to YES. Set it to NO. -- Bob Larson Access World Forums Super Moderator Tutorials at http://www.btabdevelopment.com __________________________________ "Try Hard" wrote: I have a subform that I enter data to update training files. Once I have entered the data it can not longer be seen (although it is in the appropriate table). The data is entered after using a cbo to select the correct reference to update. (ie. I select safe work procedure 1 - then enter a training date). I want to see all records accociated with this selection on the datasheet is this possible. Thanks anyone.
|
|
#4
April 14th, 2008, 08:23 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Subform not showing all records
On Apr 14, 8:31*am, Try Hard
wrote: Thanks boblarson, I have checked the DATA ENTRY properties of both the main and subform they are both set at "NO". "boblarson" wrote: Sounds like the DATA ENTRY property of the form is set to YES. *Set it to NO. -- Bob Larson Access World Forums Super Moderator Tutorials athttp://www.btabdevelopment.com __________________________________ "Try Hard" wrote: I have a subform that I enter data to update training files. Once I have entered the data it can not longer be seen (although it is in the appropriate table). The data is entered after using a cbo to select the correct reference to update. (ie. I select safe work procedure 1 - then enter a training date). I want to see all records accociated with this selection on the datasheet is this possible. Thanks anyone. Have you used "Link Child Fields" and "Link Master Fields"? Regards, Branislav Mihaljev, Microsoft Access MVP
|
|
#5
April 14th, 2008, 09:00 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Subform not showing all records
Hi Branislav
Yes I has used the "Link Child Fields" and "Link Master Fields" in the subform. " wrote: On Apr 14, 8:31 am, Try Hard wrote: Thanks boblarson, I have checked the DATA ENTRY properties of both the main and subform they are both set at "NO". "boblarson" wrote: Sounds like the DATA ENTRY property of the form is set to YES. Set it to NO. -- Bob Larson Access World Forums Super Moderator Tutorials athttp://www.btabdevelopment.com __________________________________ "Try Hard" wrote: I have a subform that I enter data to update training files. Once I have entered the data it can not longer be seen (although it is in the appropriate table). The data is entered after using a cbo to select the correct reference to update. (ie. I select safe work procedure 1 - then enter a training date). I want to see all records accociated with this selection on the datasheet is this possible. Thanks anyone. Have you used "Link Child Fields" and "Link Master Fields"? Regards, Branislav Mihaljev, Microsoft Access MVP
|
|
#6
April 14th, 2008, 09:51 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Subform not showing all records
Bye removing the "Link Child Fields" and "Link Master Fields" the records are
no longer displayed unless their are other parts of the record filled in. I would the record to stay so I can track were they are up to. Can this be done???????? Please Help! "Try Hard" wrote: Hi Branislav Yes I has used the in the subform. " wrote: On Apr 14, 8:31 am, Try Hard wrote: Thanks boblarson, I have checked the DATA ENTRY properties of both the main and subform they are both set at "NO". "boblarson" wrote: Sounds like the DATA ENTRY property of the form is set to YES. Set it to NO. -- Bob Larson Access World Forums Super Moderator Tutorials athttp://www.btabdevelopment.com __________________________________ "Try Hard" wrote: I have a subform that I enter data to update training files. Once I have entered the data it can not longer be seen (although it is in the appropriate table). The data is entered after using a cbo to select the correct reference to update. (ie. I select safe work procedure 1 - then enter a training date). I want to see all records accociated with this selection on the datasheet is this possible. Thanks anyone. Have you used "Link Child Fields" and "Link Master Fields"? Regards, Branislav Mihaljev, Microsoft Access MVP
|
| Thread Tools | |
| Display Modes | |
|
|
Hybrid Mode
