Access forms

[MCarter]

When I change an item in the background table of my form, I want the change to immediately reflect in my form's combox box. How can I accomplish this? Right now, I have to close the form, then open it again to have the change reflected.

 

[PC Datasheet]

You need to requery the combobox after you change the item in the table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

When I change an item in the background table of my form, I want the change to

immediately reflect in my form's combox box. How can I accomplish this? Right
now, I have to close the form, then open it again to have the change reflected.