Special sub-form

[dan-cat]

I have a form with a button which only becomes visible within the form under certain criteria. When this button is clicked I would like it to open a form which behaves like a sub-form - ie the user can enter data within the second form which will be linked to the main form.
I understand how to create a sub-form and link it to a main form but is there an easy way to make the sub-form visible only at the click of a button.

Dan

 

[Rich]

Use the Wizard to build your forms, select linked forms instead of subform

 

[wizcow]

Dan

You could also set your sub form to Visible=False when your main form opens.
Then have your sub form Visible=true when the button is clicked.

Tom

 

[JonatABS]

subforms

I had the same problem how ever when I try to link fields from the main form to the sub form one is a number(employeeID) and one is a text fied(Tech call Notes).

it wont work.

I want to be able to add mulitple notes to this employee everytime he calls me so I can log notes of the call.

 

[JonatABS]

subform problem

OK!! I got the whole subform main form linking issue figured out except for this error message that comes up when I try to enter a second record on the subform.