I have table with manu subdatasheets, with a 1 to many relationship.
I ma crating the main form, and I want to give the user to go to a subform ( the subdatasheet ) if they want and have the form pop up, they enter there details and carry on.
I have put on subform on my form and a command button to make it visible and another command button to turn visible to false.
when I put another subform on it gets all confused.
Is there an easier why to do this, am i doing it correctly?
Should I use option buttons and if so how?
I want the user to be able to see the related records on the form to its subform
Does that makes sense?
HELP PLEASE
H
I ma crating the main form, and I want to give the user to go to a subform ( the subdatasheet ) if they want and have the form pop up, they enter there details and carry on.
I have put on subform on my form and a command button to make it visible and another command button to turn visible to false.
when I put another subform on it gets all confused.
Is there an easier why to do this, am i doing it correctly?
Should I use option buttons and if so how?
I want the user to be able to see the related records on the form to its subform
Does that makes sense?
HELP PLEASE
H