If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filtering for a form
Hi
I have 2 forms. Form1 has a command button that loads Form2. I want user to click on the button and load up Form2 with field "SystemID" (in Form2) is blank? I think it's some sort of filtering. Thank you very much. Cindy |
#2
|
|||
|
|||
Filtering for a form
Cindy
I'm not sure I understand what 1) is happening and 2) you want to have happen. Can you describe these both? Instead of explaining how you want to use Access, can you explain what you are trying to accomplish? -- More info, please ... Jeff Boyce Access MVP |
#3
|
|||
|
|||
Filtering for a form
Hi Cindy,
Have you try to load the Form2 by using: DoCmd.Openform and pass the filtering condition SystemID=null as arg Regards, WWang -- ++++++++++++++++++++++++++++++++++++++++++++++++++ ++++ Wenjie Wang(a.k.a. William) WANG Infonology Systems Ph02)-98712018; mob:0412688380 http://users.bigpond.net.au/WISeAgent ================================================== ==== "cindy" wrote in message ... Hi I have 2 forms. Form1 has a command button that loads Form2. I want user to click on the button and load up Form2 with field "SystemID" (in Form2) is blank? I think it's some sort of filtering. Thank you very much. Cindy |
#4
|
|||
|
|||
Filtering for a form
Hi
Sorry for not explaining clearly. I've managed to do what I wanted to do before, but I'm now stuck on another thing. I have 2 tables = RequestItem and License. RequestItem is for user to enter requests to order licenses. License table has all the licenses in there, both taken and available. I have 2 forms for both tables. User enters a "License Title" and the "Machine" they want to have the license for. I want to match on 2 criterias before the License form loads up. For e.g. If I only match on 1 field, "License Title". When user types a "License Title" in RequestItem form, it'll look up in the License table with the same "License Title". E.g. User types "Access 2000", it'll look up in the License table and loads up the License form with only "Access 2000" as the License title. Coding is something like this stLinkCriteria = "[LicenseTitle]=" & Me![LicenseTitle] My problem is, what if I want to match on 2 criterias now? "LicenseTitle" AND "MachineNo", then load form. How do I do that? I don't know how to make this clearer. Hope it helps for you to help me. Thanks in advance! -----Original Message----- Hi Cindy, Have you try to load the Form2 by using: DoCmd.Openform and pass the filtering condition SystemID=null as arg Regards, WWang -- +++++++++++++++++++++++++++++++++++++++++++++++++ +++++ Wenjie Wang(a.k.a. William) WANG Infonology Systems Ph02)-98712018; mob:0412688380 http://users.bigpond.net.au/WISeAgent ================================================= ===== "cindy" wrote in message ... Hi I have 2 forms. Form1 has a command button that loads Form2. I want user to click on the button and load up Form2 with field "SystemID" (in Form2) is blank? I think it's some sort of filtering. Thank you very much. Cindy . |
Thread Tools | |
Display Modes | |
|
|