refresh problem

[Gmio]

i have a form that shows products and customer and also have adding new products and new customers form... my problem is when i add a new product and customer it doesnt show it straight away? i have to turn the form off and turn it back on again so the new details will be there

is that normal or some coding involve
cheers

 

[Dennisk]

the appropriate controls require requerying.

So if you have a buton on your main form to open an add product form (as a dialog) then the next line (executed after the dialog form has been closed) would be (assuming your products are in a combo box

me!yourComboBoxName.Requery

 

[Gmio]

the appropriate controls require requerying.

So if you have a buton on your main form to open an add product form (as a dialog) then the next line (executed after the dialog form has been closed) would be (assuming your products are in a combo box

me!yourComboBoxName.Requery

so whtever i used i should put.requery at the end right?

 

[Dennisk]

without seeing your db (and I cannot download dbs) I cannot say for sure.
try searching this forum for 'requery'