Popup Linked Form ?

[Gulf Coast Electric]

How do I link a form using child & master fields when I just want it to pop
up from the main form and be linked to it with records just matching the
record on main form.
It uses the same table and query.

Thanks,

Dave

 

[allisonrja]

Dave,

I understand child and master fields to be for sub-forms not pop-up forms. I would accomplish the pop-up by creating a new form. The new forms open event would look for the call form and extract the necessary data to create the sql statement that would then be used as the recordsource.

does that help?

 

[Pavel Romashkin]

If it *really* is based on the same data source, just reuse the
recordset from the first form. Put this in the Load event of the popup form:

Set Me.Form.Recordset = Forms("ParentForm").Form.Recordset

You could of course put this in the event that opens the popup form, in
case it gets opened separately.
Pavel

 

[Gulf Coast Electric]

Thanks, but when I open the pop up form and try to add data, it does not
keep the data in the field when I tab out of it. ???
Dave

 

[Pavel Romashkin]

I have not seen that before, always works fine for me. Could that have
anything to do with the form's design?

Pavel