VBA / Macro to filter

[Khalil Handal]

Hi,
How can I record a macro (or have a VBA code) to filter data depending on
two fields in a form.

I want to use a seperate form to identify these 2 fields.

Note:
I was able to do it following the steps in the help option in access.

Thanks in advance

 

[John W. Vinson]

Hi,
How can I record a macro (or have a VBA code) to filter data depending on
two fields in a form.

I want to use a seperate form to identify these 2 fields.

Note:
I was able to do it following the steps in the help option in access.

Thanks in advance

It's not necessary to use either a macro or VBA code. Just reference the form
with the criteria in the Query, using

=Forms![NameOfYourForm]![NameOfYourControl]

as a criterion.

John W. Vinson [MVP]

 

[Khalil Handal]

Thanks .

Hi,
How can I record a macro (or have a VBA code) to filter data depending on
two fields in a form.

I want to use a seperate form to identify these 2 fields.

Note:
I was able to do it following the steps in the help option in access.

Thanks in advance

It's not necessary to use either a macro or VBA code. Just reference the
form
with the criteria in the Query, using

=Forms![NameOfYourForm]![NameOfYourControl]

as a criterion.

John W. Vinson [MVP]

 

[Khalil Handal]

Hi,
I have a qryName based on tbl address and put :
=[Forms]![frmName]![FirstName]
in the criteria of the query called qryName
In the form property the source was qryName and when I opend the form
frmName it was empty.
Copy the:
=[Forms]![frmName]![FirstName]
in the filter property and still have the same empty form with no records.
Need more explanation / Details please.

Thanks

Hi,
How can I record a macro (or have a VBA code) to filter data depending on
two fields in a form.

I want to use a seperate form to identify these 2 fields.

Note:
I was able to do it following the steps in the help option in access.

Thanks in advance

It's not necessary to use either a macro or VBA code. Just reference the
form
with the criteria in the Query, using

=Forms![NameOfYourForm]![NameOfYourControl]

as a criterion.

John W. Vinson [MVP]

 

[John W. Vinson]

Hi,
I have a qryName based on tbl address and put :
=[Forms]![frmName]![FirstName]
in the criteria of the query called qryName
In the form property the source was qryName and when I opend the form
frmName it was empty.
Copy the:
=[Forms]![frmName]![FirstName]
in the filter property and still have the same empty form with no records.
Need more explanation / Details please.

What's in Forms!frmName!FirstName? Is the form frmName open at the time you
run the query? Why would tblAddress (which presumably contains addresses, not
names) have a field for FirstName?

Perhaps you could post the SQL view of the query and indicate what tables it
is based on.

John W. Vinson [MVP]

 

[Khalil Handal]

hi,
tblAddress is a sample table that has FirstName and LastNameName fields with
Address. I am using it for practice.
The query I am using is derived from the table tbladdress. I want the form
frmName to get only the filtered record from that query according to the
firstName.
In the Form!frmName property I have the following: (I think it is not
correct):
Record Source: qryName
Filter: =Forms!{frmName]![FirstName]

In the Query qryName under the colomn of FirstName Field in the criteria
area:
=Forms![frmName]![FirstName]

I am missing Something!!! Am I????

Khalil

Hi,
I have a qryName based on tbl address and put :
=[Forms]![frmName]![FirstName]
in the criteria of the query called qryName
In the form property the source was qryName and when I opend the form
frmName it was empty.
Copy the:
=[Forms]![frmName]![FirstName]
in the filter property and still have the same empty form with no records.
Need more explanation / Details please.

What's in Forms!frmName!FirstName? Is the form frmName open at the time
you
run the query? Why would tblAddress (which presumably contains addresses,
not
names) have a field for FirstName?

Perhaps you could post the SQL view of the query and indicate what tables
it
is based on.

John W. Vinson [MVP]

 

[John W. Vinson]

hi,
tblAddress is a sample table that has FirstName and LastNameName fields with
Address. I am using it for practice.
The query I am using is derived from the table tbladdress. I want the form
frmName to get only the filtered record from that query according to the
firstName.
In the Form!frmName property I have the following: (I think it is not
correct):
Record Source: qryName
Filter: =Forms!{frmName]![FirstName]

In the Query qryName under the colomn of FirstName Field in the criteria
area:
=Forms![frmName]![FirstName]

I am missing Something!!! Am I????

You're doing it backwards. You are trying to use frmName as both the criterion
to filter the table, and also to display the results of that query! It can't
be both!

You need some unbound (nothing in its Control Source) textbox or combo box to
serve as the criterion; and then, separately, a bound control to display the
result of the query.

John W. Vinson [MVP]

 

[Khalil Handal]

Thanks for making it clear.

hi,
tblAddress is a sample table that has FirstName and LastNameName fields
with
Address. I am using it for practice.
The query I am using is derived from the table tbladdress. I want the form
frmName to get only the filtered record from that query according to the
firstName.
In the Form!frmName property I have the following: (I think it is not
correct):
Record Source: qryName
Filter: =Forms!{frmName]![FirstName]

In the Query qryName under the colomn of FirstName Field in the criteria
area:
=Forms![frmName]![FirstName]

I am missing Something!!! Am I????

You're doing it backwards. You are trying to use frmName as both the
criterion
to filter the table, and also to display the results of that query! It
can't
be both!

You need some unbound (nothing in its Control Source) textbox or combo box
to
serve as the criterion; and then, separately, a bound control to display
the
result of the query.

John W. Vinson [MVP]