Popup Linked Form ?

  • Thread starter Thread starter Gulf Coast Electric
  • Start date Start date
G

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
 
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?
 
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
 
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
 
I have not seen that before, always works fine for me. Could that have
anything to do with the form's design?

Pavel
 
Back
Top