Filtering for a form

[cindy]

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

 

[Jeff Boyce]

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?

 

[William Wenjie Wang]

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) (e-mail address removed)
WANG Infonology Systems Ph02)-98712018; mob:0412688380
http://users.bigpond.net.au/WISeAgent
======================================================

 

[cindy]

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!