textbox and combobox

  • Thread starter Thread starter alpapak via AccessMonster.com
  • Start date Start date
A

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
 
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
 
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
------------------------------------------------------------------------------
Click to expand...
[quoted text clipped - 24 lines]
to find "Check" which it is not visible. If i close form and open it again ,
it works
Click to expand...
Click to expand...
 
Back
Top