Subform Flicker - Just One Time

[Cindy]

I have a form with two subforms that are "in synch" with each other -
the bottom form displays records based on the selection in the first
form. The second, synchronized, subform allows data entry.

Everything works fine. All data entry gets saved properly.

EXCEPT every time I enter data on the subform, there is a brief
flicker before the cursor moves to the next field. The record
navigation buttons quickly disappear and then reappear.

There is NO conditional formatting on the forms (I DID have some, but
removed it just in case it's contributing).

The first subform (sfrmTG1) is filtered by it's underlying query, the
link child / link master properties are empty.

The second subform has link child = lngCaseID; lngMasterID
Link Master Fields = unbCaseID; unbMasterID1

The two master fields for the link are calculated controls on the
parent object (frmMilestones) holding the subforms.

unbCaseID = [Forms]![frmMaster]![lngCaseID] (which is a form that is
always open when frmMilestones is open).

unbMasterID1 = [sfrmTG1].[Form]![lngMilestoneID]

Any thoughts on what could cause the flicker? It's problematic when
the user goes into a combo box entry - the flicker sometimes
interferes with the data entry. If the user just tabs through the
form, they see the flicker, but all seems to work pretty well. I'm
not comfortable ignoring the flicker......have a feeling it bodes bad
things to come......!!!

Thanks in advance.

Cindy

 

[banem2]

I have a form with two subforms that are "in synch" with each other -
the bottom form displays records based on the selection in the first
form. The second, synchronized, subform allows data entry.

Everything works fine. All data entry gets saved properly.

EXCEPT every time I enter data on the subform, there is a brief
flicker before the cursor moves to the next field. The record
navigation buttons quickly disappear and then reappear.

There is NO conditional formatting on the forms (I DID have some, but
removed it just in case it's contributing).

The first subform (sfrmTG1) is filtered by it's underlying query, the
link child / link master properties are empty.

The second subform has link child = lngCaseID; lngMasterID
Link Master Fields = unbCaseID; unbMasterID1

The two master fields for the link are calculated controls on the
parent object (frmMilestones) holding the subforms.

unbCaseID = [Forms]![frmMaster]![lngCaseID] (which is a form that is
always open when frmMilestones is open).

unbMasterID1 = [sfrmTG1].[Form]![lngMilestoneID]

Any thoughts on what could cause the flicker? It's problematic when
the user goes into a combo box entry - the flicker sometimes
interferes with the data entry. If the user just tabs through the
form, they see the flicker, but all seems to work pretty well. I'm
not comfortable ignoring the flicker......have a feeling it bodes bad
things to come......!!!

Thanks in advance.

Cindy

It looks like your queries don't provide data quickly enough. I will
suggest to create subform with subform and use Master/Child. Then
place subform (with subform) on main form and again use Master/Child
while at the same time you should remove filters from queries. Each
requery takes some time and if there are larger amount of data it will
produce blinks.

Regards,
Branislav Mihaljev

 

[Cindy]

I have a form with two subforms that are "in synch" with each other -
the bottom form displays records based on the selection in the first
form. The second, synchronized, subform allows data entry.

Everything works fine. All data entry gets saved properly.

EXCEPT every time I enter data on the subform, there is a brief
flicker before the cursor moves to the next field. The record
navigation buttons quickly disappear and then reappear.

There is NO conditional formatting on the forms (I DID have some, but
removed it just in case it's contributing).

The first subform (sfrmTG1) is filtered by it's underlying query, the
link child / link master properties are empty.

The second subform has link child = lngCaseID; lngMasterID
Link Master Fields = unbCaseID; unbMasterID1

The two master fields for the link are calculated controls on the
parent object (frmMilestones) holding the subforms.

unbCaseID = [Forms]![frmMaster]![lngCaseID] (which is a form that is
always open when frmMilestones is open).

unbMasterID1 = [sfrmTG1].[Form]![lngMilestoneID]

Any thoughts on what could cause the flicker? It's problematic when
the user goes into a combo box entry - the flicker sometimes
interferes with the data entry. If the user just tabs through the
form, they see the flicker, but all seems to work pretty well. I'm
not comfortable ignoring the flicker......have a feeling it bodes bad
things to come......!!!

Branislav - the queries run very fast - they are very straightforward,
and I've only got about 20 records in the tables right now!

These subforms are on a tab control - I've got two sets of subforms on
each tab control, and therefore can't modify the design this way. (I
also removed all other subforms to make sure that the number of
subforms wasn't causing the problem - but I have the problem with just
one set of them).

????

 

[banem2]

I have a form with two subforms that are "in synch" with each other -
the bottom form displays records based on the selection in the first
form. The second, synchronized, subform allows data entry.
Everything works fine. All data entry gets saved properly.
EXCEPT every time I enter data on the subform, there is a brief
flicker before the cursor moves to the next field. The record
navigation buttons quickly disappear and then reappear.
There is NO conditional formatting on the forms (I DID have some, but
removed it just in case it's contributing).
The first subform (sfrmTG1) is filtered by it's underlying query, the
link child / link master properties are empty.
The second subform has link child = lngCaseID; lngMasterID
Link Master Fields = unbCaseID; unbMasterID1
The two master fields for the link are calculated controls on the
parent object (frmMilestones) holding the subforms.
unbCaseID = [Forms]![frmMaster]![lngCaseID] (which is a form that is
always open when frmMilestones is open).
unbMasterID1 = [sfrmTG1].[Form]![lngMilestoneID]
Any thoughts on what could cause the flicker? It's problematic when
the user goes into a combo box entry - the flicker sometimes
interferes with the data entry. If the user just tabs through the
form, they see the flicker, but all seems to work pretty well. I'm
not comfortable ignoring the flicker......have a feeling it bodes bad
things to come......!!!

Branislav - the queries run very fast - they are very straightforward,
and I've only got about 20 records in the tables right now!

These subforms are on a tab control - I've got two sets of subforms on
each tab control, and therefore can't modify the design this way. (I
also removed all other subforms to make sure that the number of
subforms wasn't causing the problem - but I have the problem with just
one set of them).

????

It looks like your queries don't provide data quickly enough. I will
suggest to create subform with subform and use Master/Child. Then
place subform (with subform) on main form and again use Master/Child
while at the same time you should remove filters from queries. Each
requery takes some time and if there are larger amount of data it will
produce blinks.

Regards,
Branislav Mihaljev

Hi Cindy,

Are there any code which run during flicker? If there any, please copy
it here. I assume you have used normalization and indexed ID fields?

Regards,
Branislav Mihaljev

 

[banem2]

I have a form with two subforms that are "in synch" with each other -
the bottom form displays records based on the selection in the first
form. The second, synchronized, subform allows data entry.
Everything works fine. All data entry gets saved properly.
EXCEPT every time I enter data on the subform, there is a brief
flicker before the cursor moves to the next field. The record
navigation buttons quickly disappear and then reappear.
There is NO conditional formatting on the forms (I DID have some, but
removed it just in case it's contributing).
The first subform (sfrmTG1) is filtered by it's underlying query, the
link child / link master properties are empty.
The second subform has link child = lngCaseID; lngMasterID
Link Master Fields = unbCaseID; unbMasterID1
The two master fields for the link are calculated controls on the
parent object (frmMilestones) holding the subforms.
unbCaseID = [Forms]![frmMaster]![lngCaseID] (which is a form that is
always open when frmMilestones is open).
unbMasterID1 = [sfrmTG1].[Form]![lngMilestoneID]
Any thoughts on what could cause the flicker? It's problematic when
the user goes into a combo box entry - the flicker sometimes
interferes with the data entry. If the user just tabs through the
form, they see the flicker, but all seems to work pretty well. I'm
not comfortable ignoring the flicker......have a feeling it bodes bad
things to come......!!!

Branislav - the queries run very fast - they are very straightforward,
and I've only got about 20 records in the tables right now!

These subforms are on a tab control - I've got two sets of subforms on
each tab control, and therefore can't modify the design this way. (I
also removed all other subforms to make sure that the number of
subforms wasn't causing the problem - but I have the problem with just
one set of them).

????

It looks like your queries don't provide data quickly enough. I will
suggest to create subform with subform and use Master/Child. Then
place subform (with subform) on main form and again use Master/Child
while at the same time you should remove filters from queries. Each
requery takes some time and if there are larger amount of data it will
produce blinks.

Regards,
Branislav Mihaljev

Hi Cindy,

Are there any code which run during flicker? If there any, please copy
it here. I assume you have used normalization and indexed ID fields?

Regards,
Branislav Mihaljev

 

[Cindy]

Yes - database is normalized and fields are indexed.
I discovered that Access was actually saving the subform record with
every field entry - really weird behavior that I haven't seen before.

I ended up going with your first suggestion, Branislov - in rethinking
the design I realized I could tie the "holder" of the two subforms to
the case ID, and change the subform to link off the parent object
instead.

It did the trick - so many thanks!

Cindy

On Aug 3, 8:56 pm, (e-mail address removed) wrote:

I have a form with two subforms that are "in synch" with each other -
the bottom form displays records based on the selection in the first
form. The second, synchronized, subform allows data entry.
Everything works fine. All data entry gets saved properly.
EXCEPT every time I enter data on the subform, there is a brief
flicker before the cursor moves to the next field. The record
navigation buttons quickly disappear and then reappear.
There is NO conditional formatting on the forms (I DID have some, but
removed it just in case it's contributing).
The first subform (sfrmTG1) is filtered by it's underlying query, the
link child / link master properties are empty.
The second subform has link child = lngCaseID; lngMasterID
Link Master Fields = unbCaseID; unbMasterID1
The two master fields for the link are calculated controls on the
parent object (frmMilestones) holding the subforms.
unbCaseID = [Forms]![frmMaster]![lngCaseID] (which is a form that is
always open when frmMilestones is open).
unbMasterID1 = [sfrmTG1].[Form]![lngMilestoneID]
Any thoughts on what could cause the flicker? It's problematic when
the user goes into a combo box entry - the flicker sometimes
interferes with the data entry. If the user just tabs through the
form, they see the flicker, but all seems to work pretty well. I'm
not comfortable ignoring the flicker......have a feeling it bodes bad
things to come......!!!

Branislav - the queries run very fast - they are very straightforward,
and I've only got about 20 records in the tables right now!

These subforms are on a tab control - I've got two sets of subforms on
each tab control, and therefore can't modify the design this way. (I
also removed all other subforms to make sure that the number of
subforms wasn't causing the problem - but I have the problem with just
one set of them).

Hi Cindy,

Are there any code which run during flicker? If there any, please copy
it here. I assume you have used normalization and indexed ID fields?

Regards,
Branislav Mihaljev