Not in list error when form has limit to list = no auto correct =

  • Thread starter Thread starter terry beckman
  • Start date Start date
T

terry beckman

I had code in not in list as I need to open fields for a new entry that are
filled in when in list.
Private Sub PatientID_NotInList(NewData As String, Response As Integer)
Me.BirthDate.Locked = False
Me.Race1.Locked = False
Me.BirthDate.BackColor = 16777215
Me.Race1.BackColor = 16777215
End Sub
Took this out and still getting limit to list error message. This is Access
2003 I believe. Need to fix for client soon.
Please help
Thanks!
Terry
 
That would not be the correct place to put that code. It should go in the
After Update event of the comb.

If you want to avoid the Access Not In List message, you need to create your
own. You can bypass any message at all, but that would confuse a user.
Look in VBA Help for the Not In List event. It has a good example of how to
handle this event.
 
I have set limit to list = no and auto correct = no. I have seen posts on
the internet that if there is no limit to list event that this should handle
the issue.
Cannot do a direct select as list is compiled from two tables with a left
join between
tblaftercare.PatientID and new_mcc_intake.YouthID.
Most fields are required so cannot insert a temp holding record and update.
Thanks!
Terry
 
Trapped the error and found it was -2337. Could this be an issue with setup
and MSAccess and the Server, but got the same error when I moved this to my
hard drive.
Terry
 
Back
Top