Subform not showing all records

[Try Hard]

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.

 

[boblarson]

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]

Thanks boblarson, I have checked the DATA ENTRY properties of both the main
and subform they are both set at "NO".

 

[banem2]

Thanks boblarson, I have checked the DATA ENTRY properties of both the main
and subform they are both set at "NO".

Have you used "Link Child Fields" and "Link Master Fields"?

Regards,
Branislav Mihaljev, Microsoft Access MVP

 

[Try Hard]

Hi Branislav
Yes I has used the "Link Child Fields" and "Link Master Fields" in the
subform.

 

[Try Hard]

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!

 

[Rick Brandt]

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.

 

[Try Hard]

Thanks for your comments Rick. I have a number of tables they are:

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