textbox and combobox

[alpapak via AccessMonster.com]

textbox and combobox
------------------------------------------------------------------------------
--

hi

i have a table
Pay
PayID
Surname
PayType

i made a form using this table and after a while i deside to change [PayType]
from TextBox to ComboBox
the combobox will show me the entries of [PayType] so i will not have to
write each time
Also , i want to add new

until here everything is ok
My problem is that :
when i add a new and click new record , i can not see the new enty until i
close my form and open it again.

example:
i type a new [PayType] = "check"
i move to new record , write [Surname] , i click to the combobox and i want
to find "Check" which it is not visible. If i close form and open it again ,
it works

 

[Guest]

To get the new entry in the combo box, you will need to requery it. You
don't say if you are using the After Update or the Not In List event of the
combo to add the new value, but right after you add the new value:

Me.MyComb.Requery

 

[alpapak via AccessMonster.com]

thxs for the reply

i found it after i post the message
but thank you very much for reading it and be so kind to help me.

To get the new entry in the combo box, you will need to requery it. You
don't say if you are using the After Update or the Not In List event of the
combo to add the new value, but right after you add the new value:

Me.MyComb.Requery

textbox and combobox
------------------------------------------------------------------------------

[quoted text clipped - 24 lines]

to find "Check" which it is not visible. If i close form and open it again ,
it works