hi all

looking for bit of help really

i am using VBA with access and i trying to code a serch button on my form

i have 8 textboxes on a my form whihc all coreesponding to their relevant feilds in the table. when i press the serach button a new form opens with a text fields and a continue button.

now this is where i am stumped. when the value is etered into the text box i would like it to serch all 8 columns in my table and then display the corresponding information on my main form.

i have tried to code it but it just laughs at me.
i am a bit of a notive when it comes to access but i am learning.
could anyone shed a bit of light on this

or advise a different course of action
many thnaks