Search Command button

[praveenkanaka]

Hi,

I'm working on database to store n retrive data from the master table(13 feilds , EmpId feild is the primary key). I have 2 forms. Main form is used to enter the date into table. The second form i used to pull the data from the master table nad display the same in 2nd form. I want to create a search button, which should pull data from master table based on the Empid mentioned on the form. Please help me how to do this task.

Thanks in Advance!!!

[PianoMan64]

I have a few quetions:

1. Are you wanting to store the results from the Master Table into another table based on the EmpID field specified in the search Criteria?

2. How is the Form and the Sub Form linked, if at all?

Let me know.

Just as a future suggestion when posting a question, You have a very clear understanding of what problem you're trying to solve, just think of it, that the person you're asking the question from, doesn't know anything about what you're wanting the end result to be as well as what you've done so far. There isn't any detail at all as to what you have developed, or what code or formulas you've created already.. These are things that we need to know as a community in order to assist other people with there questions.

Hope that helps,

Joe P.