Round Robin form

[Guest]

I am creating a "Round Robin" form (an interactive form that lets users
specify the parameters of a report to be run).

Currently the drop down list to choose from is: A, B, C. The report shows
that all the records are "A" if you select A from the list box, if you select
"B", then it shows all the records are "B" (even though the table has an
equal amount of A, B and C).

The criteria in my Query is:
[Forms]![frmATMSecurityTriForm]![cboAlarmPanelType].

Any suggestions on how to fix so that it only brings back the records that
match the selection in the list box and not changes all the records to match
the particular choice?

Let me know if I need to be more descriptive...it makes sense to me, but....

 

[Guest]

You said that the query is filtered by the selection from the combo, post the
SQL of the query.

I assume that the report is based on this query


--
Good Luck
BS"D

What do you mean the "full SQL"? Not sure where I would get this from.
I'm just using a query, form and Report in Access

Can you post the full SQL?

--
Good Luck
BS"D

I am creating a "Round Robin" form (an interactive form that lets users
specify the parameters of a report to be run).

Currently the drop down list to choose from is: A, B, C. The report shows
that all the records are "A" if you select A from the list box, if you select
"B", then it shows all the records are "B" (even though the table has an
equal amount of A, B and C).

The criteria in my Query is:
[Forms]![frmATMSecurityTriForm]![cboAlarmPanelType].

Any suggestions on how to fix so that it only brings back the records that
match the selection in the list box and not changes all the records to match
the particular choice?

Let me know if I need to be more descriptive...it makes sense to me, but....

 

[Guest]

Hmmm maybe I am missing something but the way that you describe it it sounds
like it would be correct.

This is what I hear you say. You have a report. That report is based on a
query. That query has sql something like Select * from table where
AlarmPanelType = [Forms]![frmATMSecurityTriForm]![cboAlarmPanelType]. You can
see the SQL of the query by looking at the toolbar dropdown that toggles
between design, datasheet, and SQL view. It should be shown as the farthest
left button.

I believe that this is the SQL that Ofer was asking for. If there is no
query, but you built it in the report, then just copy out the ControlSource
for the Report and that would be the SQL.

Here is another thing to think about. If you open a report and keep it open
then reopen, it will not refresh. So you may need to check if it is open,
close it if it is open, and then reopen it if you are seeing that your data
is not being refreshed. I am not so great at macros, but I can give you VBA
code to do it if you want.

Let me know if this solves your problems or if I can be of more assistance.

 

[Guest]

I found the SQL code, so here it is.

SELECT tblATMMasterList.strATMID, tblATMAlarmPanelType.strAlarmPanelType
FROM tblATMAlarmPanelType, tblATMMasterList
WHERE
(((tblATMAlarmPanelType.strAlarmPanelType)=[Forms]![frmATMSecurityTriForm]![cboAlarmPanelType]));

Hopes this helps. I thought it was set up correctly too. Any further help
is always much appreciated.

Hmmm maybe I am missing something but the way that you describe it it sounds
like it would be correct.

This is what I hear you say. You have a report. That report is based on a
query. That query has sql something like Select * from table where
AlarmPanelType = [Forms]![frmATMSecurityTriForm]![cboAlarmPanelType]. You can
see the SQL of the query by looking at the toolbar dropdown that toggles
between design, datasheet, and SQL view. It should be shown as the farthest
left button.

I believe that this is the SQL that Ofer was asking for. If there is no
query, but you built it in the report, then just copy out the ControlSource
for the Report and that would be the SQL.

Here is another thing to think about. If you open a report and keep it open
then reopen, it will not refresh. So you may need to check if it is open,
close it if it is open, and then reopen it if you are seeing that your data
is not being refreshed. I am not so great at macros, but I can give you VBA
code to do it if you want.

Let me know if this solves your problems or if I can be of more assistance.

I am creating a "Round Robin" form (an interactive form that lets users
specify the parameters of a report to be run).

Currently the drop down list to choose from is: A, B, C. The report shows
that all the records are "A" if you select A from the list box, if you select
"B", then it shows all the records are "B" (even though the table has an
equal amount of A, B and C).

The criteria in my Query is:
[Forms]![frmATMSecurityTriForm]![cboAlarmPanelType].

Any suggestions on how to fix so that it only brings back the records that
match the selection in the list box and not changes all the records to match
the particular choice?

Let me know if I need to be more descriptive...it makes sense to me, but....

 

[Guest]

Hi Jeff
The SQL look fine,
If you would like to post the mdb to
chamudim <@> hotmail <dot> com

I can have a look, mybe I'll get a better Idea
--
Good Luck
BS"D

I found the SQL code, so here it is.

SELECT tblATMMasterList.strATMID, tblATMAlarmPanelType.strAlarmPanelType
FROM tblATMAlarmPanelType, tblATMMasterList
WHERE
(((tblATMAlarmPanelType.strAlarmPanelType)=[Forms]![frmATMSecurityTriForm]![cboAlarmPanelType]));

Hopes this helps. I thought it was set up correctly too. Any further help
is always much appreciated.

Hmmm maybe I am missing something but the way that you describe it it sounds
like it would be correct.

This is what I hear you say. You have a report. That report is based on a
query. That query has sql something like Select * from table where
AlarmPanelType = [Forms]![frmATMSecurityTriForm]![cboAlarmPanelType]. You can
see the SQL of the query by looking at the toolbar dropdown that toggles
between design, datasheet, and SQL view. It should be shown as the farthest
left button.

I believe that this is the SQL that Ofer was asking for. If there is no
query, but you built it in the report, then just copy out the ControlSource
for the Report and that would be the SQL.

Here is another thing to think about. If you open a report and keep it open
then reopen, it will not refresh. So you may need to check if it is open,
close it if it is open, and then reopen it if you are seeing that your data
is not being refreshed. I am not so great at macros, but I can give you VBA
code to do it if you want.

Let me know if this solves your problems or if I can be of more assistance.

I am creating a "Round Robin" form (an interactive form that lets users
specify the parameters of a report to be run).

Currently the drop down list to choose from is: A, B, C. The report shows
that all the records are "A" if you select A from the list box, if you select
"B", then it shows all the records are "B" (even though the table has an
equal amount of A, B and C).

The criteria in my Query is:
[Forms]![frmATMSecurityTriForm]![cboAlarmPanelType].

Any suggestions on how to fix so that it only brings back the records that
match the selection in the list box and not changes all the records to match
the particular choice?

Let me know if I need to be more descriptive...it makes sense to me, but....

 

[Guest]

Thanks everyone for their help. As I was paring the database down to email
it, I found my error. I was pulling from referecing tables in the initial
query (instead of the main table).

So everything now works how I want it to.

Thanks again.

Hi Jeff
The SQL look fine,
If you would like to post the mdb to
chamudim <@> hotmail <dot> com

I can have a look, mybe I'll get a better Idea
--
Good Luck
BS"D

I found the SQL code, so here it is.

SELECT tblATMMasterList.strATMID, tblATMAlarmPanelType.strAlarmPanelType
FROM tblATMAlarmPanelType, tblATMMasterList
WHERE
(((tblATMAlarmPanelType.strAlarmPanelType)=[Forms]![frmATMSecurityTriForm]![cboAlarmPanelType]));

Hopes this helps. I thought it was set up correctly too. Any further help
is always much appreciated.

Hmmm maybe I am missing something but the way that you describe it it sounds
like it would be correct.

This is what I hear you say. You have a report. That report is based on a
query. That query has sql something like Select * from table where
AlarmPanelType = [Forms]![frmATMSecurityTriForm]![cboAlarmPanelType]. You can
see the SQL of the query by looking at the toolbar dropdown that toggles
between design, datasheet, and SQL view. It should be shown as the farthest
left button.

I believe that this is the SQL that Ofer was asking for. If there is no
query, but you built it in the report, then just copy out the ControlSource
for the Report and that would be the SQL.

Here is another thing to think about. If you open a report and keep it open
then reopen, it will not refresh. So you may need to check if it is open,
close it if it is open, and then reopen it if you are seeing that your data
is not being refreshed. I am not so great at macros, but I can give you VBA
code to do it if you want.

Let me know if this solves your problems or if I can be of more assistance.

:

I am creating a "Round Robin" form (an interactive form that lets users
specify the parameters of a report to be run).

Currently the drop down list to choose from is: A, B, C. The report shows
that all the records are "A" if you select A from the list box, if you select
"B", then it shows all the records are "B" (even though the table has an
equal amount of A, B and C).

The criteria in my Query is:
[Forms]![frmATMSecurityTriForm]![cboAlarmPanelType].

Any suggestions on how to fix so that it only brings back the records that
match the selection in the list box and not changes all the records to match
the particular choice?

Let me know if I need to be more descriptive...it makes sense to me, but....