A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Subform not showing all records



 
 
Thread Tools Display Modes
  #1  
Old April 14th, 2008, 05:02 AM posted to microsoft.public.access.forms
Try Hard[_2_]
external usenet poster
 
Posts: 18
Default 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  
Old April 14th, 2008, 07:21 AM posted to microsoft.public.access.forms
boblarson
external usenet poster
 
Posts: 886
Default 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  
Old April 14th, 2008, 07:31 AM posted to microsoft.public.access.forms
Try Hard[_2_]
external usenet poster
 
Posts: 18
Default 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  
Old April 14th, 2008, 08:23 AM posted to microsoft.public.access.forms
[email protected]
external usenet poster
 
Posts: 130
Default 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  
Old April 14th, 2008, 09:00 AM posted to microsoft.public.access.forms
Try Hard[_2_]
external usenet poster
 
Posts: 18
Default 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  
Old April 14th, 2008, 09:51 AM posted to microsoft.public.access.forms
Try Hard[_2_]
external usenet poster
 
Posts: 18
Default 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  
Old April 14th, 2008, 12:19 PM posted to microsoft.public.access.forms
Rick Brandt
external usenet poster
 
Posts: 4,354
Default 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  
Old April 14th, 2008, 11:40 PM posted to microsoft.public.access.forms
Try Hard[_2_]
external usenet poster
 
Posts: 18
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:24 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.