Blank subform problem

pd06498

Registered User.
Local time
Tomorrow, 06:56
Joined
Dec 30, 2003
Messages
80
In the form I have created, I have a combo from where I select an employee. Once this is selected, the subform in the form should show the list of training, and the dates the employee completed each. (The training list is only 3 records long and is the same for each employee, just the dates are changed to show current competency, i.e. 3 subjects that remain the same).
When I select an employee, the subform is blank, I mean totally blank, nothing at all. Yet when I open the subform by itself, it is just the way I want it with the 3 listed subjects, and blank dates waiting for new dates to be added.
I've linked the form and subform through the employee numbers on both forms.

Does anyone have any ideas what my problem here might be?
 
Have you linked the main form to the subform in the relationships window?

For a quick test try making a new main form, does it make a subform at the same time?

If it doesn’t make a subform at the same time, then when it’s in design mode, drank the subform onto it. Hopefully that should work!
 
Thanks Gizmo

The relationship between the two tables is a many-to-many (don't know if that is the cause of the problem). Reason for that is that each employee must maintain these 3 skills as current (taken from the date skill obtained/refreshed), and I would like to keep a record of each time they completed each one.

pd06498
 

Users who are viewing this thread

Back
Top Bottom