Requery Help

[lashwarj]

I have a combo box that when double clicked on will open an entry screen to
add new drop down fields, Question : How do I get this to requery instead of
having to exit the program and go back in I believe it has to do with the
requery but what code would I need to place in the requery option to accomplish

 

[ramani]

WHEN THE CONTROL IS RETURNED FROM THE CALLED PROGRAMME OR FORM - ISSUE THE COMMAND
REQUERRY()

 

[lashwarj]

Where in the main form would I do this and what do I need for code just requery()

 

[ramani]

I presume that you have succeeded till the new fields in the drop down. This is done by you in doubleclick event. So at the end of the same event you can add the line
requerry()
Or you can refresh() in the above place and in the refresh event you can requerry().

I hope I have understood you problem correctly. It depends on the circumstances and other codes involved. If you need speciic help, if you make the code available to me, I can be specific.

Ramani
ramani_g@yahoo.com

 

[jonscott8]

lashwarj,

As I said in thread184-64505, you have to notify the combobox to requery its rowsource using the requery method of the combobox. For example,

MyComboBox.Requery

The REQUERY command has no relevance to refreshing the combobox unless the rowsource of the combobox is a view. In that case you would requery the view and then requery the combobox. For Example,

REQUERY('MyViewAlias')
MyComboBox.Requery

Refer to the VFP documentation for further explanation. Jon Hawkins

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed