Run time error in a form

Steve,

Yes, the subform supposed to show recordes based on the choice in the combo
box.

Yes, the combo box is on the main form called Mnform_RQM_Pend_Upd

I've recreated combo box and the query several times so the most current
combobox is called RCA_Name. I got that name from combobox --- properties --
other tab---name.



"Steve Schapel" wrote:

Monia,

Thanks. My understanding was that the subform is supposed to show the
records according to the selection in the combobox. Is that right? The
combobox is apparently on a from called Mnform_RQM_Pend_Upd, is that
right? According to the code you showed earlier, the name of the
combobox is RCA, is that right? Therefore I would have expected the
WHERE clause of the query to refer to RCA, not RCA_Name, i.e. like this....
WHERE (([RQM Pending - by RCA].[RCA
Name])=[Forms]![Mnform_RQM_Pend_Upd]![RCA])
Can you clarify?

--
Steve Schapel, Microsoft Access MVP


monia13 wrote:
Here is the code:

SELECT [RQM Pending - by RCA].[RCA Name], [RQM Pending - by RCA].[Acct
Date], [RQM Pending - by RCA].[CAS ID], [RQM Pending - by RCA].[Client ID],
[RQM Pending - by RCA].[Client Name], [RQM Pending - by RCA].[Pendign Stats],
[RQM Pending - by RCA].Comments
FROM [RQM Pending - by RCA]
WHERE ((([RQM Pending - by RCA].[RCA
Name])=[Forms]![Mnform_RQM_Pend_Upd]![RCA_Name]));

Steve,

I recreated combo box and subform query for the nth time. In the combo
box, I chose RCA ID (indexed field) along with RCA Name. I adjusted the query
to filter on RCA ID picked in the combo box. Subform populates now when a
value in the como box is chosen. Thanks for your help.

"Steve Schapel" wrote:

Monia,

Thanks. My understanding was that the subform is supposed to show the
records according to the selection in the combobox. Is that right? The
combobox is apparently on a from called Mnform_RQM_Pend_Upd, is that
right? According to the code you showed earlier, the name of the
combobox is RCA, is that right? Therefore I would have expected the
WHERE clause of the query to refer to RCA, not RCA_Name, i.e. like this....
WHERE (([RQM Pending - by RCA].[RCA
Name])=[Forms]![Mnform_RQM_Pend_Upd]![RCA])
Can you clarify?

--
Steve Schapel, Microsoft Access MVP


monia13 wrote:
Here is the code:

SELECT [RQM Pending - by RCA].[RCA Name], [RQM Pending - by RCA].[Acct
Date], [RQM Pending - by RCA].[CAS ID], [RQM Pending - by RCA].[Client ID],
[RQM Pending - by RCA].[Client Name], [RQM Pending - by RCA].[Pendign Stats],
[RQM Pending - by RCA].Comments
FROM [RQM Pending - by RCA]
WHERE ((([RQM Pending - by RCA].[RCA
Name])=[Forms]![Mnform_RQM_Pend_Upd]![RCA_Name]));