Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Combobox list update

Status
Not open for further replies.

georgp

Technical User
Mar 28, 2002
96
US
Hello,

how do I get the new value just entered into a combobox control ('ucbo_System', linked to a table field) show up after the control has been updated but without record change in the dropdown list?
I tried the requery method in the controls after_update event, but it doesn't work, neither does the ucbo_System.Rowsource = "....." in the appropriate event of another control.
I have checked with another control that the value is accepted by the table.
When I go to the next record then the value is included into the dropdown list.
I thought it would be no problem...

Thanks, georgp
 
try
DoCmd.RunCommand acCmdSaveRecord
in the after update event

Hope this helps
Hymn
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top