Hey guys I am not sure what I am doing wrong or if this is the way to go
I created two text boxes text1 and text2
text1 is unbound
text2 is bound to table1
I would like to have the form look up information based on what I put in text1 so if I put in sugar
text2 will bring up sugar
but I would like the form to search anypart of the text so I used the docmd.findrecord let me know if I am on the right track with this one
dim field as string
field = "text2"
docmd.FindRecord,acEntire,field,acSearchAll,like,acAll
I created two text boxes text1 and text2
text1 is unbound
text2 is bound to table1
I would like to have the form look up information based on what I put in text1 so if I put in sugar
text2 will bring up sugar
but I would like the form to search anypart of the text so I used the docmd.findrecord let me know if I am on the right track with this one
dim field as string
field = "text2"
docmd.FindRecord,acEntire,field,acSearchAll,like,acAll