I have a combo box which lists suppliers and their details are displayed in text boxes on my form. When I open this form the first supplier record always shows the details for supp 1 in the text boxes. I want these text boxes to be blank until a record in the combo box is chosen.

Can anyone offer me some advice?

Many thanks
Hayley

If you make all of the text box's data source come from a query and have that query filtered by the combo box you will get what you want.

If you can't figure this out send me an email and I will walk you through it.

I already have a filter in the query that runs my form to sort the records in ascending order. Am I correct in saying there can only be one filter per query?

If so is there any other way to do this?

Thanks again
Hayley

Des has been a great help and got this working for me on my search form by changing the record source to the table not the query that I had it set to. I am trying to implement this same procedure into my delete forms but it doesnt seem to be working. I get a prompt when I load the form asking me for an id no. Ive also had a run time error which point to the bookmark.

Have I just missed something out or cant this be done on a delete form?

Thank you again for your help!!