my subform is blinking??

[adaniele]

Hi all, this is very uncommon...
I have a form. Inside this form i added a subform whic works perfectly. However, if i add a third subform, both subforms start to blink and i cant use them.

In the form i have information about a task (primary key: change_id from newchange table). In the first subform i have information about subtasks (primary key: change_id2 + subtask from change_desc table) and in the new subform i have a trail log of the ticket (primary key: historyID from history table).

any help?

 

[Pat Hartman]

Do you have code that is putting Access into a loop that is causing the flicker?

 

[adaniele]

coding

The main form is tabbed. I wanted to add the audit trail in the last tab.
The main form has code on load, on close, when the user press the save button and when a field is modifyed.

Do u want to see the code?
thx

 

[adaniele]

code

This form allowes the user to modify records and each time that a record is changed the audit trail table is updated (when the save button is pressed.

it helps?

 

[Pat Hartman]

Well, it is your code that is probably causing the problem. Try stepping through it to see if it is in a never ending loop.

 

[adaniele]

i think that the problem is the link between the form and the subform. if i delete the linking fields, the subform shows me the audit trail of all the tasks and it does not blink.
suggestions?

 

[Pat Hartman]

Your code is causing the problem. It is putting Access into a loop trying to keep the subform refreshed.

 

[adaniele]

The problem was the linking fields. fixed it.
thx

 

[Pat Hartman]

Did you have the wrong fields in the master/child links? If you just remove the master/child link, Access won't keep the forms synchronized.

 

[adaniele]

The main form has a field called change_id. Also, it is a tabbed form with 5 tabs where the last one is used to show the audit trail log of the ticket.
So, the Audit tab has a subform which gets the info from a query, then i removed the linking fields and filtered the query with the chang_id field from the main form.

thx