C
Chaster
I have this combo on my form and am getting can't go to specified record
error?
Private Sub Combo29_NotInList(NewData As String, Response As Integer)
DoCmd.GoToRecord , , acNewRec
Me.BusinessStreet = Me.Combo29
Me.Company.SetFocus
End Sub
The form that Combo29 is on is a modular form. I don't know if this would
have anything to do with it but just incase I mention it.
Understanding the application might help.
We solict business from people who attend conventions. We enter data from
directories that we pick up at the shows. Some are very large and contain
duplicate information. We are not aware the information is duplicated
because 1 company may carry many lines and be in the book several times
under different names.
We have found that most of the time, even if the company name is different,
that the BusinessStreet address is the same.
I have put Combo29 on my form and would like to input the BusinessStreet
information which I can see is either in my list or not. (I have set the
limit to list property to no). If the record is in the list I just want to
be able to ESC and start with a new search. If the data that is being
inputed is not in the list I want to open a new record, transfer the data
that was inputed into Combo29 to the [BusinessStreet] field in the new
record, and have the cursor go to the [Company] field so that we can start
putting in that companies information.
TIA
error?
Private Sub Combo29_NotInList(NewData As String, Response As Integer)
DoCmd.GoToRecord , , acNewRec
Me.BusinessStreet = Me.Combo29
Me.Company.SetFocus
End Sub
The form that Combo29 is on is a modular form. I don't know if this would
have anything to do with it but just incase I mention it.
Understanding the application might help.
We solict business from people who attend conventions. We enter data from
directories that we pick up at the shows. Some are very large and contain
duplicate information. We are not aware the information is duplicated
because 1 company may carry many lines and be in the book several times
under different names.
We have found that most of the time, even if the company name is different,
that the BusinessStreet address is the same.
I have put Combo29 on my form and would like to input the BusinessStreet
information which I can see is either in my list or not. (I have set the
limit to list property to no). If the record is in the list I just want to
be able to ESC and start with a new search. If the data that is being
inputed is not in the list I want to open a new record, transfer the data
that was inputed into Combo29 to the [BusinessStreet] field in the new
record, and have the cursor go to the [Company] field so that we can start
putting in that companies information.
TIA