can someone please tell me what i am doing wrong?

[Son268]

hi there all,

I cant work out what I am doin wrong. I have set up a form which has an unbound field on it called 'marker number'. On the form there is a command button which runs a macro to perform a search based on what is entered in the field 'marker number'. I have done this before thanks to some excellent advice from Jack Cowley. However this time the field doesnt seem to be using the data in the unbound field. I have used the criteria Like [Forms]![Marker Number]![MarkerNumber] & "*". When I run the query with the parameter box it works fine but I dont want to use a parameter box on the front end....it must be somethin simple please help!!! When I run it from the form it just returns all the records....highly annoying!!!

Many thanks
Sonya B

 

[kaspi]

Hi Sonya
Try to rename your text box (txt_Box) and change the reference in your query. (It seems that the control name is the same as the field name ??? (Access can get confused)
Kaspi