G
Guest
There is a situation in which the client uses 2 fields in the table as the
primary key. In a search field (Combo59) the 2 fields are concatenated
together and called FileNumber thru a query. I get a type mismatch error in
the after update event of the combobox. Below is the code that is used and
inorder to do a search, the 2 table fields will need to concatenated together
inorder for "FileNumber" to do the search.
Me.RecordsetClone.FindFirst NewFindFirst("[FileNumber]",
Str(Me![Combo59]))
Me.Bookmark = Me.RecordsetClone.Bookmark
I am at a loss as to how to go about doing a search using a concat cbo
against 2 fields in a table and seek assistance. Also, don't be to harsh on
the naming conventions or process as this is coming from a new client that
had their "neighbor" develop this and I am now the lucky one to fix it.
Thank you inadvance for any assistance.
primary key. In a search field (Combo59) the 2 fields are concatenated
together and called FileNumber thru a query. I get a type mismatch error in
the after update event of the combobox. Below is the code that is used and
inorder to do a search, the 2 table fields will need to concatenated together
inorder for "FileNumber" to do the search.
Me.RecordsetClone.FindFirst NewFindFirst("[FileNumber]",
Str(Me![Combo59]))
Me.Bookmark = Me.RecordsetClone.Bookmark
I am at a loss as to how to go about doing a search using a concat cbo
against 2 fields in a table and seek assistance. Also, don't be to harsh on
the naming conventions or process as this is coming from a new client that
had their "neighbor" develop this and I am now the lucky one to fix it.
Thank you inadvance for any assistance.