Filter Sub Form

[ahd2008]

Good day all,

I have a main form( its name Main) which contains a sub form(its name KPI). I put a button on the main form to call a search window. This search window requires the user to enter the employee id. After that when the user click the button, it should filter the data on sub form.

I used this code, but it doesnt work properly
can anyone help out

DoCmd.OpenForm "Main", acNormal, , "id =" & empid

[ahd2008]

Any suggestion plz ?

[NeoPa]

Please do not *BUMP* your thread before at least 24 hours have passed.
This is a forum site. Not paid for support. Our experts and members offer their time on a voluntary basis, and deserve a little patience from those who may benefit from their efforts.

Administrator.

[NeoPa]

First, I suggest reading through Example Filtering on a Form. This is a bit different, in that you are working with a subform rather than a separate form, but the concepts are the same.

Come back if and when you need to be taken further (You may see the concepts and be fine from there).

[ahd2008]

Sorry fot that and thanks for your suggestion.
Although it is hard to me to understand, but i will give it a shot

[NeoPa]

@ahd2008
Give it a shot, and then at least your questions and your ability to understand the answer will be better prepared.

We're here to fill in the gaps anyway.

Another link may prove helpful to you (Referring to Items on a Sub-Form).

A fundamental difference between opening a separate form and an already opened sub-form, is of course, that you don't call a function to open the sub-form. This route is therefore denied you. We will need to look more closely at the specifics of that when you're ready for it.