This hopefully is an easy question. I have a database that I use to keep track of client information. The information is kept in a table. The way I search is by using an unbound textbox in a form. I have a command button that does the search, which operates correctly. The problem that I am having is that I want to display the result in another textbox in the form. I've tried using macros but the SetValue command doesn't let me set the value of the textbox.

Start again with a new form. The form needs to be bound to a table or query (ie have a recordsource). Select the fields you want to see on the form. Then add an unbound (no controlsource) combobox. One of the options offered by the combobox wizard will be to find a particular record.

Thanks for the advice, although is there any way that I could use the textbox tool instead of the combobox? It's not too suitable for the interface.

Combo boxes are going to be the easiest way to do this, you can type directly into them (if you have the AutoExpand on, it helps) instead of using the dropdown arrows. Just make sure the field is wide enough to accommodate your widest entry+the drop-down arrow.

HTH,
David R

You can use an unbound text field and a command button. But, I think that you may have to modify the code generated by the command button. Try it.