Search record

[spiderz78]

Hi to all of you. I am having problem with a form.that is I have a form where i Put a text box to input data to be searched and I have a command button which after you input the search data in the textbox and click on the command,it searches the table and display it in athe subform.Can anyone please help me how to do it.Thanks all of you in advance

[JustJim]

Hi to all of you. I am having problem with a form.that is I have a form where i Put a text box to input data to be searched and I have a command button which after you input the search data in the textbox and click on the command,it searches the table and display it in athe subform.Can anyone please help me how to do it.Thanks all of you in advance

Hi,
It is a fairly common and simple task to have a text box (actually more commonly a combo box) control on the header of a form and a command button (or an AfterUpdate event for the combo box) to find and display data in the main body of the same form (subforms not being required for this). Is this sort of what you had in mind?

Please post more detailed information about your aims and we'll see what we can do.

Jim

[spiderz78]

Yes thank you for replying. i want to have a text box on a form,when the user enter the data in the text box then he click on the command button and it display all details for that particular record. Can you please explain me in details what step and how i can do it.thank you in advance Jim.