By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,226 Members | 1,435 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,226 IT Pros & Developers. It's quick & easy.

Filter Sub Form

P: 68
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

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "Main", acNormal, , "id =" & empid
May 10 '09 #1
Share this Question
Share on Google+
5 Replies


P: 68
Any suggestion plz ?
May 11 '09 #2

NeoPa
Expert Mod 15k+
P: 31,707
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.
May 11 '09 #3

NeoPa
Expert Mod 15k+
P: 31,707
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).
May 11 '09 #4

P: 68
Sorry fot that and thanks for your suggestion.
Although it is hard to me to understand, but i will give it a shot
May 12 '09 #5

NeoPa
Expert Mod 15k+
P: 31,707
@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.
May 12 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.