Pop up form displays same details for ever record

[JimJones]

Hi,

This database is continually giving me problems.

I've even included a graphic of my relationships, so you know the set up.

I have a Main form. In that main form is a subform

Within that subform is another subform.

I don't wish to try new designs anymore. Every time I do, get more problems.


OK, so I click on the button to pop up my form, and it is supposed to display service details for each customer(from main form).

But the pop-up form, which is based on its own table won't update it's customer and service ticket fields. IT Does so, on the form only ! , but not in the underlying table.

Have I provded enough detail?

Please help,
Jim

 

[JimJones]

Hi again,
More accurately, the pop up form displays the same data for every record, but NOT on the pop up form itself, only in the table.

Please help,
Jim

 

[neileg]

Not at all clear what you mean, which explains why your screen grab has had lots of views, but no replies.

Specifically, I don't know what your subforms show, nor your pop-up form.

Nevertheless, I'll jump in.

Normally, when you create a subform and add this to a main form, Access figures out what the link is between the two lots of data. When you create a pop-up form, you have to create the link. What would be usual is to base your pop-up on a query, and for the query to have a criterion that looked at a field on your main form or one of the subforms. So suppose your pop-up links to the main form by way of the customer ID, the criterion might be Forms.frmMainForm.txtCustID in the field of the query that holds the customer ID.

Re-reading your post, I wonder if your are trying to base your forms on the tables. It is preferable to use queries to base your forms on for just the reason we are discussing.

 

[JimJones]

Thanks for your response.

I will try to describe just the problem I am having, as best as I can.

I have a main form. WIthin that main form is a subform. Within that subform is another subform. That nested subform has a button which popus up a form. That form, which is supposed to display a field from the nested subform, does not display it.

I can enter fields into that pop up form, and they all get reflected in the table, except for the linked field, from the nested subform.

I acknowledge your suggestion about basing it on queries, but this project is almost done, and it's been based on tables.

Can you help?
Thanks,
Jim

Not at all clear what you mean, which explains why your screen grab has had lots of views, but no replies.

Specifically, I don't know what your subforms show, nor your pop-up form.

Nevertheless, I'll jump in.

Normally, when you create a subform and add this to a main form, Access figures out what the link is between the two lots of data. When you create a pop-up form, you have to create the link. What would be usual is to base your pop-up on a query, and for the query to have a criterion that looked at a field on your main form or one of the subforms. So suppose your pop-up links to the main form by way of the customer ID, the criterion might be Forms.frmMainForm.txtCustID in the field of the query that holds the customer ID.

Re-reading your post, I wonder if your are trying to base your forms on the tables. It is preferable to use queries to base your forms on for just the reason we are discussing.

 

[neileg]

One of the reasons to use queries is so that you can do just what you need to do. You don't have to rework everything, just use a query for your final pop-up form. Make sure that the query uses the full name of the control of your subsubform as the criterion for the linked field, e.g. [forms]![frm1]![subfrm2]![subsubfrm3]![txttbl3ID]