reference Option Group to Table

[scjohn]

can some one explain to me how i reference a option group buttons to a table. the table has 7 locations listed in it. i want each button to point to a different location. I have completed a SQL statment for a command button but when i run it i get a error that there is:
The Specified field '[ResourcesTypeID]' could refer to more than one table listed in the from clause of the SQL statment.
I understand what this means but how do you correct this?? this is the SQL Statment that i have.

Select Case Me!frLocation
'filter record source dependant on option checked
Case 1
strFilterSQL = strSQL & " Where [ResourceTypeID] = 'Fellowship Hall';"

Case 2
strFilterSQL = strSQL & " Where [ResourceTypeID] = 'Confrence Room';"

Case 3
strFilterSQL = strSQL & " Where [ResourceTypeID] = 'Chapel';"

Case 4
strFilterSQL = strSQL & " Where [ResourceTypeID] ='Chapel Lounge';"

Case 5
strFilterSQL = strSQL & " Where [ResourceTypeID] = 'Chapel Kitchen';"

Case 6
strFilterSQL = strSQL & " Where [ResourceTypeID] = 'Small Chape';"

Case 7
strFilterSQL = strSQL & " Where [ResourceTypeID] = 'Choir Room';"

Case Else
strFilterSQL = strSQL & ";"

End Select

can some one please help.

 

[scjohn]

sorry, this is the SQL statment:

'set default record source of form
Const strSQL = "SELECT Schedule.ScheduleDate, [Schedule Details].ScheduleStartTime, [Schedule Details].ScheduleEndTime, Resources.ResourceTypeID, Resources.ResourceName FROM (([Resource Types] INNER JOIN Resources ON [Resource Types].ResourceTypeID=Resources.ResourceTypeID) INNER JOIN Schedule ON Resources.ResourceID=Schedule.ResourceID) INNER JOIN [Schedule Details] ON Schedule.ScheduleID=[Schedule Details].ScheduleID"

 

[scjohn]

Maybe Im Asking To Be Explained, Normaly How Would You Reference A Option Group So That It Would Store The Id's For A Table? This Is The Only Part Holding Me Up, Please Help Me Out.