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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
#7
|
|||
|
|||
Subform not showing all records
Try Hard wrote:
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???????? It is done all the time. Sounds like you have incorrect relationships between the two tables or that you do not have the relationship properly configured with the MasterLink and ChildLink properties. What field or fields relate the two tables? Those same fields are what should be entered into the link properties of the subform. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#8
|
|||
|
|||
Subform not showing all records
Thanks for your comments Rick. I have a number of tables they a
Employeetble Employee Name (PK) Positiontble Position Name (PK) Work Intructiontble Position Name WI Description Competencytble Employee Name Position Name WI Description Date Trained I am trying to use the competency table to record training for different work instructions for employees, work instruction must be allocated to a position and an employee to a position (nb. an employee can have a number a positions hence a great deal of work instructions). Your help is appreciated. Thanks "Rick Brandt" wrote: Try Hard wrote: 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???????? It is done all the time. Sounds like you have incorrect relationships between the two tables or that you do not have the relationship properly configured with the MasterLink and ChildLink properties. What field or fields relate the two tables? Those same fields are what should be entered into the link properties of the subform. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|