Form and Control Refresh Issues

[megmogg]

Hi All

I have a base class form that when it gets the focus, it requeries all the controls on the form. This is because each control is getting data from SQL Server.

I have user form that is a search screen. Top half of the screen are combos that filter what appears in a grid below.

Each combo refreshes the grid when it recieves focus or on interactive change.

Trouble is, when the user is in another form and they click back onto this one, the form itself refreshes the data, which is fine, but if a combo box has focus, it then gets the data again.

I dont want to stop the form doing a refresh because when a user navigates back to this form and nothing has the focus, they will be seeing old data.

I am sure it is just a matter of structuring everything, but need some suggestions as I am getting lost in my own code.

Any fresh ideas?

Thanks

 

[DSummZZZ]

I think I would avoid a refresh when a combo box 'got' focus. and reserve it for a LostFocus or interactive change. The value wouldn't change at that time anyway.



-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[megmogg]

Thanks for the suggestion....think I'll heed that advice.