Filtering to look up the correct record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good day,

I am working on a database that keeps track of checks (checks are composed
of a "Symbol" and "SerialNo") and how many times that particular check has
been requested. I created a form "CheckHistory" that shows me the Check No
(in the main form) and its history (in a subform) after I searched for that
Check No.
If the same check has been requested 3 times, the subform will show me the 3
different times it was requested. After a request has been processed I will
need to updated.

I have created an "Edit" button that is using a macro to open the EditForm,
which is suppose to show me that particular record (in the subform) I want to
edit. I am having trouble making the macro work properly.
I have tried the following conditions:

([Symbol]='1234') And ([SerialNo]="12345678") <---This condition shows me
just that Check's History no matter if I click on a different record under a
different Check No.
If I replace the numbers with ", ', or # it does not work.

([ReferenceID]=[ReferenceID]) <--- It shows me all the records of all the
checks, not filtering as it should.

Please help. What is the correct condition I need to use?

Thank you,

JRG
 
May it is me that is confused but it seems like you are trying to use a macro
condition to filter. If this is what you are trying it will not work as
conditions for a macro test to see if the macro should run or not.
 
I am trying to use a macro condition to filter because for whatever reason,
when I added a botton, to open a form, by using Access' wizard and linking
the ReferenceID from the CheckHistory subform to the ReferenceID in the
EditForm it would not work. I would get an error message that read:
"Object or class does not support the set of events"

I am not sure why or how to fix this problem, but my solution was to create
a macro. The macro opens the correct form, but it does not provide me with
the correct information.

Sorry for confusing you, I tend to do that. =D Hope this helps you
understand a bit more.

Thank you,
JRG


KARL DEWEY said:
May it is me that is confused but it seems like you are trying to use a macro
condition to filter. If this is what you are trying it will not work as
conditions for a macro test to see if the macro should run or not.
--
KARL DEWEY
Build a little - Test a little


JRG said:
Good day,

I am working on a database that keeps track of checks (checks are composed
of a "Symbol" and "SerialNo") and how many times that particular check has
been requested. I created a form "CheckHistory" that shows me the Check No
(in the main form) and its history (in a subform) after I searched for that
Check No.
If the same check has been requested 3 times, the subform will show me the 3
different times it was requested. After a request has been processed I will
need to updated.

I have created an "Edit" button that is using a macro to open the EditForm,
which is suppose to show me that particular record (in the subform) I want to
edit. I am having trouble making the macro work properly.
I have tried the following conditions:

([Symbol]='1234') And ([SerialNo]="12345678") <---This condition shows me
just that Check's History no matter if I click on a different record under a
different Check No.
If I replace the numbers with ", ', or # it does not work.

([ReferenceID]=[ReferenceID]) <--- It shows me all the records of all the
checks, not filtering as it should.

Please help. What is the correct condition I need to use?

Thank you,

JRG
Click to expand...
Click to expand...
 
What action were you planning to use in the macro?
--
KARL DEWEY
Build a little - Test a little


JRG said:
I am trying to use a macro condition to filter because for whatever reason,
when I added a botton, to open a form, by using Access' wizard and linking
the ReferenceID from the CheckHistory subform to the ReferenceID in the
EditForm it would not work. I would get an error message that read:
"Object or class does not support the set of events"

I am not sure why or how to fix this problem, but my solution was to create
a macro. The macro opens the correct form, but it does not provide me with
the correct information.

Sorry for confusing you, I tend to do that. =D Hope this helps you
understand a bit more.

Thank you,
JRG


KARL DEWEY said:
May it is me that is confused but it seems like you are trying to use a macro
condition to filter. If this is what you are trying it will not work as
conditions for a macro test to see if the macro should run or not.
--
KARL DEWEY
Build a little - Test a little


JRG said:
Good day,

I am working on a database that keeps track of checks (checks are composed
of a "Symbol" and "SerialNo") and how many times that particular check has
been requested. I created a form "CheckHistory" that shows me the Check No
(in the main form) and its history (in a subform) after I searched for that
Check No.
If the same check has been requested 3 times, the subform will show me the 3
different times it was requested. After a request has been processed I will
need to updated.

I have created an "Edit" button that is using a macro to open the EditForm,
which is suppose to show me that particular record (in the subform) I want to
edit. I am having trouble making the macro work properly.
I have tried the following conditions:

([Symbol]='1234') And ([SerialNo]="12345678") <---This condition shows me
just that Check's History no matter if I click on a different record under a
different Check No.
If I replace the numbers with ", ', or # it does not work.

([ReferenceID]=[ReferenceID]) <--- It shows me all the records of all the
checks, not filtering as it should.

Please help. What is the correct condition I need to use?

Thank you,

JRG
Click to expand...
Click to expand...
Click to expand...
 
I was planning on using the OpenForm action so that when the macro is
executed it can open the "EditForm".


--
JRG


KARL DEWEY said:
What action were you planning to use in the macro?
--
KARL DEWEY
Build a little - Test a little


JRG said:
I am trying to use a macro condition to filter because for whatever reason,
when I added a botton, to open a form, by using Access' wizard and linking
the ReferenceID from the CheckHistory subform to the ReferenceID in the
EditForm it would not work. I would get an error message that read:
"Object or class does not support the set of events"

I am not sure why or how to fix this problem, but my solution was to create
a macro. The macro opens the correct form, but it does not provide me with
the correct information.

Sorry for confusing you, I tend to do that. =D Hope this helps you
understand a bit more.

Thank you,
JRG


KARL DEWEY said:
May it is me that is confused but it seems like you are trying to use a macro
condition to filter. If this is what you are trying it will not work as
conditions for a macro test to see if the macro should run or not.
--
KARL DEWEY
Build a little - Test a little


:

Good day,

I am working on a database that keeps track of checks (checks are composed
of a "Symbol" and "SerialNo") and how many times that particular check has
been requested. I created a form "CheckHistory" that shows me the Check No
(in the main form) and its history (in a subform) after I searched for that
Check No.
If the same check has been requested 3 times, the subform will show me the 3
different times it was requested. After a request has been processed I will
need to updated.

I have created an "Edit" button that is using a macro to open the EditForm,
which is suppose to show me that particular record (in the subform) I want to
edit. I am having trouble making the macro work properly.
I have tried the following conditions:

([Symbol]='1234') And ([SerialNo]="12345678") <---This condition shows me
just that Check's History no matter if I click on a different record under a
different Check No.
If I replace the numbers with ", ', or # it does not work.

([ReferenceID]=[ReferenceID]) <--- It shows me all the records of all the
checks, not filtering as it should.

Please help. What is the correct condition I need to use?

Thank you,

JRG
Click to expand...
Click to expand...
Click to expand...
 
As I said a conditions for a macro test to see if the macro should run or not.
So any condition you use will only control whether the form will open, not
what records it will display.

--
KARL DEWEY
Build a little - Test a little


JRG said:
I was planning on using the OpenForm action so that when the macro is
executed it can open the "EditForm".


--
JRG


KARL DEWEY said:
What action were you planning to use in the macro?
--
KARL DEWEY
Build a little - Test a little


JRG said:
I am trying to use a macro condition to filter because for whatever reason,
when I added a botton, to open a form, by using Access' wizard and linking
the ReferenceID from the CheckHistory subform to the ReferenceID in the
EditForm it would not work. I would get an error message that read:
"Object or class does not support the set of events"

I am not sure why or how to fix this problem, but my solution was to create
a macro. The macro opens the correct form, but it does not provide me with
the correct information.

Sorry for confusing you, I tend to do that. =D Hope this helps you
understand a bit more.

Thank you,
JRG


:

May it is me that is confused but it seems like you are trying to use a macro
condition to filter. If this is what you are trying it will not work as
conditions for a macro test to see if the macro should run or not.
--
KARL DEWEY
Build a little - Test a little


:

Good day,

I am working on a database that keeps track of checks (checks are composed
of a "Symbol" and "SerialNo") and how many times that particular check has
been requested. I created a form "CheckHistory" that shows me the Check No
(in the main form) and its history (in a subform) after I searched for that
Check No.
If the same check has been requested 3 times, the subform will show me the 3
different times it was requested. After a request has been processed I will
need to updated.

I have created an "Edit" button that is using a macro to open the EditForm,
which is suppose to show me that particular record (in the subform) I want to
edit. I am having trouble making the macro work properly.
I have tried the following conditions:

([Symbol]='1234') And ([SerialNo]="12345678") <---This condition shows me
just that Check's History no matter if I click on a different record under a
different Check No.
If I replace the numbers with ", ', or # it does not work.

([ReferenceID]=[ReferenceID]) <--- It shows me all the records of all the
checks, not filtering as it should.

Please help. What is the correct condition I need to use?

Thank you,

JRG
Click to expand...
Click to expand...
Click to expand...
 
Thank you for your help.

JRG


KARL DEWEY said:
As I said a conditions for a macro test to see if the macro should run or not.
So any condition you use will only control whether the form will open, not
what records it will display.

--
KARL DEWEY
Build a little - Test a little


JRG said:
I was planning on using the OpenForm action so that when the macro is
executed it can open the "EditForm".


--
JRG


KARL DEWEY said:
What action were you planning to use in the macro?
--
KARL DEWEY
Build a little - Test a little


:

I am trying to use a macro condition to filter because for whatever reason,
when I added a botton, to open a form, by using Access' wizard and linking
the ReferenceID from the CheckHistory subform to the ReferenceID in the
EditForm it would not work. I would get an error message that read:
"Object or class does not support the set of events"

I am not sure why or how to fix this problem, but my solution was to create
a macro. The macro opens the correct form, but it does not provide me with
the correct information.

Sorry for confusing you, I tend to do that. =D Hope this helps you
understand a bit more.

Thank you,
JRG


:

May it is me that is confused but it seems like you are trying to use a macro
condition to filter. If this is what you are trying it will not work as
conditions for a macro test to see if the macro should run or not.
--
KARL DEWEY
Build a little - Test a little


:

Good day,

I am working on a database that keeps track of checks (checks are composed
of a "Symbol" and "SerialNo") and how many times that particular check has
been requested. I created a form "CheckHistory" that shows me the Check No
(in the main form) and its history (in a subform) after I searched for that
Check No.
If the same check has been requested 3 times, the subform will show me the 3
different times it was requested. After a request has been processed I will
need to updated.

I have created an "Edit" button that is using a macro to open the EditForm,
which is suppose to show me that particular record (in the subform) I want to
edit. I am having trouble making the macro work properly.
I have tried the following conditions:

([Symbol]='1234') And ([SerialNo]="12345678") <---This condition shows me
just that Check's History no matter if I click on a different record under a
different Check No.
If I replace the numbers with ", ', or # it does not work.

([ReferenceID]=[ReferenceID]) <--- It shows me all the records of all the
checks, not filtering as it should.

Please help. What is the correct condition I need to use?

Thank you,

JRG
Click to expand...
Click to expand...
Click to expand...
 
Back
Top