Need to refresh my DTC drop-down.

[Guest_imported]

Hello. After adding a new record, my DTC drop-down needs to show the new value - but doesn't until after I exit the page and re-enter. Is there a way to make it refresh automatically on Save?

Thanks for your help,
Anna

 

[MerlinB]

You should:
1. myDropDown.Clear
2. rsMyRecordset.Open
3. rsMyRecordset.Close (no need to keep it open)
4. myDropDown.AddItem "add any additional entries"

You can plonk this in the thisPage_onenter()* event code so it runs every time the page loads. Or put it with the code that performs the Add/Delete functions.



*[add a Page Object DTC, then select the event in the Script Outline window (Server Objects & Events / thisPage / onenter)]

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)