Combo Box (New Data)

  • Thread starter Thread starter WTC
  • Start date Start date
W

WTC

When using a form (A) in a combo box (B) and does have the Value I want, I
use the Not In List Event. this works fine.
So a form (E) opens to enter a new value. I enter the new value. When I
close the form (E), the value is listed in the Combo box (B) but it is not
in the Drop Down list.

I am wondering why?

Example of my code

If IsLoaded("A") Then
Forms!A!B.Undo
Forms!A!C.SetFocus
Forms!A!B.Requery
Forms!A!B = D

DoCmd.Close
Else

DoCmd.GoToRecord , , acNewRec
End If
 
I am sorry about posting twice, but I seen a mistake. Should have proof read
it.

When using a form (A) in a combo box (B) and does NOT have the Value I want,
I use the Not In List Event. this works fine. So a form (E) opens to enter a
new value. I enter the new value. When I close the form (E), the value is
listed in the Combo box (B) but it is not in the Drop Down list.

I am wondering why?

Example of my code

If IsLoaded("A") Then
Forms!A!B.Undo
Forms!A!C.SetFocus
Forms!A!B.Requery
Forms!A!B = D

DoCmd.Close
Else

DoCmd.GoToRecord , , acNewRec
End If
 
Back
Top