Would like to get a pop up form to act the same as a subform

[SomeGuy]

Instead of having a subform on my main form (which I currently have and it works fine), I would like to use a command button on my main form to open up a form that does the same kind of job as the subform did (Have child records that link to the parent record).

I tried to do this by linking the parent records unique key# to a field in the child record (which the child record uses as a reference to know which parent record it is associated to) so it seems to have the same kind of link that the subform did.

However, unlike the subform which allows me to view records that have already been entered and to enter new ones, the new form that opens up with the command button only allows me to view the old child records but not add any new ones.

The word (filtered) shows up just to the right of the record number on the record selector at the bottom of the form. When I advance to a new record on the child form, it no longer shows the unique key# but instead shows the number zero. This is obviously due to the fact that it cannot find anymore child records associated with the parent record.

I would like to get this form to work like the subform did but I haven't had much luck yet.

 

[Fornatian]

Try setting the default value of the linked field in your pop-up form to the primary ref on the parent form - Forms![MyForm]![MyPrimaryID].

Ian

 

[SomeGuy]

Thanks a lot. That was exactly what I needed.