getting past " Item Not In List "


Mark Kubicki

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

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

on the main form, I have this code:

Private Sub Manufacturer_NotInList(NewData As String, Response As
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...)

Tom van Stiphout

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.

Microsoft Access MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question