form selectively displays subform items

[miken5678]

I have attached a copy of the db. You can scroll through the items and even search within the policy field and note that only one policy number pulls the subform info up which is confusing me as to why the rest arent. The policy number is 1092467. If you look at the tables the data is there it just wont display within the MAIN form.

I have compacted repaired and not changed a thing this has just randomly happened to me. It was previously split as a fe/back end without issue. I even used a new front end and imported all the back end tables and still come up with this. Does anyone notice any issue with the coding?

Any help is appreciated on this.

thanks

mike

 

[MarkK]

It appears to me that the LinkMasterFields property of the subform on Main refers to a field that does not appear on the parent form.

 

[miken5678]

i guess i can understand that but if that was the case it would have never worked to begin with. what i noticed is that scrolling through the policy numbers will not scroll the sub forms but the transaction type number and lob should pull the subform. I thought it would be an issue with the if statements..

if i am to change the link master fields what should i link that to.. the policy number?

 

[miken5678]

nm, I am lost as i didnt think that item would be required on the main form as the if statements reference the transaction type and subform

 

[MarkK]

Is there a relationship between the tables? You need to use the fields on which the table data are linked. If there is no such link in the underlying data, then there is no meaningful way to relate parent/child forms.

 

[miken5678]

yes all tables are linked to the tblMainHeader

 

[MarkK]

- So the linked fields must each appear on the form to which they belong. If you don't wish to display this data, set the .visible property of the control to false.
- Also, I believe that the LinkMasterFields and LinkChildFields properties of the subform control refer to control names, not field names.
- Set these values to the names of the controls that contain the data on which the tables are linked, and Access handles the rest, including providing the parent's link data to the child form when adding a new record.
- Keep me posted.

 

[miken5678]

you will like this.. i have a friend that is on another access board that has helped me big time.. i sent him a copy of the db and he had no issues.. upon sending it back and relinking it now works for me.. i have no clue if this is an access fluke or do to the fact he might be using 07.....

needless to say i am going through to see any changes in code and definetly making a daily backup

i will keep you posted if i can find anything different.. i did note that the linked table items are still the same..

also for future reference i can assign an individual sub form with linked items without using the if statement and let it work based on a user input? like in my db run it off of the transaction type and line of business and let the linked table item pull the correct form?