getting past " Item Not In List "

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

I am trying to add an item NOT IN LIST to the datasource table (without
success).
My pop-up form has no data source, and the data entry text boxes are
unbound,

I am having 2 problems:
1 - when the pop-up form opens, I get an error message that the TEXT IS
NOT AN ITEM IN LIST (we know that, the purpose of opening the form is to add
the item to the list)
2 - when I return to the main form, it seems to already be past checking
if the item is in the list (?) When I hit enter, to navigate out of that
field, which has "data limited to list", it is not checking to see if the
entry is in the now updated list; consequently, it is not firing code that
enables other controls that would normally be locked until that field was
validated with an entry.

ANY suggestions wouldbe greatly appreciated
as always, thanks in advance
mark


--------------------------------------
on the main form, I have this code:

Private Sub Manufacturer_NotInList(NewData As String, Response As
Integer)
On Error GoTo Err_Manufacturer_NotInList
...
stDocName = "frmManufacturer_PopUp"
Response = acDataErrAdded
DoCmd.OpenForm stDocName, acNormal, , , acReadOnly, , NewData

--------------------------------------
on the pop-up form I have this code:

Private Sub Form_Open(Cancel As Integer)
strNewManufacturer = me.OpenArgs
Me.txtManufacturerName = strNewManufacturer
...
End Sub

but the result is not the value I want,but the name of a control on the
pop-up form (?)
(also, i get an error, not in list message when the pop-up form opens -but I
really haven't looked into this...)
 
On Tue, 31 Mar 2009 11:49:37 -0400, "Mark Kubicki"

You need to look up DoCmd.OpenForm in the help file. acDialog does not
work as the second argument.

-Tom.
Microsoft Access MVP
 
Back
Top