I have a combo box that finds the record that I type in
this is the code I placed in the after update event
dim rs as object
set rs = me.recordset.clone
rs.findfirst "[Item number] = ' "&me! [combo2]& "'"
me.bookmark = rs.bookmark
This code works fine but I want to be able to type in part of the string and have it display alist of records that have
this substring in it.
can someone please help.
Thank You,
Travis
this is the code I placed in the after update event
dim rs as object
set rs = me.recordset.clone
rs.findfirst "[Item number] = ' "&me! [combo2]& "'"
me.bookmark = rs.bookmark
This code works fine but I want to be able to type in part of the string and have it display alist of records that have
this substring in it.
can someone please help.
Thank You,
Travis