Tab Flickers!

[Madison123]

Hi There! I need help again, this is driving me insane I have three Tabs. On the first Tab I enter information and select submit. This adds the values to a Table. Fine. The second Tab, searches this table based on a value i insert into a textbox. However, when i select search the whole tab flickers. I have looked at AllenBrownes recommendation regarding unattached labels and i dont think that is the issue. When i comment put my code and just press the buttons its fine. I have 7,700 rows that it is searching could this be it?



Private Sub Search_Click() 'Searching

Dim message
Set rst = Me.RecordsetClone ' new code
Me.Requery

Me.RecordsetClone.FindFirst "[TRCSNNumber] = '" & Me![SN] & "' or[SerialNumber2] = '" & Me![SN] & "' or[SerialNumber3] = '" & Me![SN] & "' "

If rst.NoMatch = False Then
Me.Bookmark = rst.Bookmark
FindNext.Visible = True
Else
message = MSGBOX("The Number you have entered cannot be Found", vbOKOnly)

End If
End Sub

 

[gemma-the-husky]

well, if you have an unattached label, and rollover it with the mouse, that definitely makes a flicker.

the other thing that may do it, in this case is

me.requery

that requeries the whole record set, and will cause whatever is displayed on your form to clear and redisplay.

depends exactly what you are doing, but me.refresh may be sufficient

 

[Madison123]

Thanks for the advice but unfortunately I took it out and it didnt work.. would you believe it was actually there as i thought that might stop it..

I thought it might be happening because it had to search through the whole table but then i deleted a load of rows to make it a small table and it still flickers! so frustraining now.. i know its oging to end up being something simple too!

 

[vbaInet]

Do you have calculated control sources? Move them to the record source.

 

[Madison123]

Do you have calculated control sources? Move them to the record source.

Thaks for helping!

For the control source for each textbox I have the field name in the table where the info is coming from.

Then in the form i have the Record Source set to that table. Is that correct? The information coming back is all correct.

 

[vbaInet]

That seems ok to me. Can you post a stripped down version of your db so we can test it? Remember to indicate the problem form and steps to take to reproduce the problem.