How To Change Form RecordSet

On Jul 4, 6:32 am, scubadiver <scubadi....DeleteThis@discussions.microsoft.com>
wrote:
> In the 'onclick' event of the option box I would probably try something like
>
> if me.checkbox.value = -1 then me.Form.Recordset = "tblclients"
>
>
>
> "Duck" wrote:
> > I have a form that is used to display patient records.  It's default
> > Recordset is set to a query which shows only current clients.  I want
> > to use an option box on the form to force the form to use the client
> > table (tblClients) as it's source Recordset, which would display ALL
> > clients (past and present), not just current clients.  How do I
> > accomplish this?- Hide quoted text -
>
> - Show quoted text -

I tried that already and would get "Operation is not supported for
this type of object" error My code is:

If Me.optAllOrCurrent.Value = 1 Then
Me.Form.Recordset = "qryCurrentClients"
Else
Me.Form.Recordset = "qryCurrentClientsAll"
End If

The optionbox can have a value of either 1 (default) or 2

you want to be using RecordSOURCE not recordSET





On Jul 4, 7:09 am, Duck <charles.kendri....RemoveThis@charter.net> wrote:
> On Jul 4, 6:32 am, scubadiver <scubadi....RemoveThis@discussions.microsoft.com>
> wrote:
>
> > In the 'onclick' event of the option box I would probably try something like
>
> > if me.checkbox.value = -1 then me.Form.Recordset = "tblclients"
>
> > "Duck" wrote:
> > > I have a form that is used to display patient records.  It's default
> > > Recordset is set to a query which shows only current clients.  I want
> > > to use an option box on the form to force the form to use the client
> > > table (tblClients) as it's source Recordset, which would display ALL
> > > clients (past and present), not just current clients.  How do I
> > > accomplish this?- Hide quoted text -
>
> > - Show quoted text -
>
> I tried that already and would get "Operation is not supported for
> this type of object" error  My code is:
>
> If Me.optAllOrCurrent.Value = 1 Then
>     Me.Form.Recordset = "qryCurrentClients"
> Else
>     Me.Form.Recordset = "qryCurrentClientsAll"
> End If
>
> The optionbox can have a value of either 1 (default) or 2

On Jul 4, 8:17 am, "a a r o n . k e m p f @ g m a i l . c o m"
<aaron.ke....DeleteThis@gmail.com> wrote:
> you want to be using RecordSOURCE not recordSET
>
> On Jul 4, 7:09 am, Duck <charles.kendri....DeleteThis@charter.net> wrote:
>
>
>
> > On Jul 4, 6:32 am, scubadiver <scubadi....DeleteThis@discussions.microsoft.com>
> > wrote:
>
> > > In the 'onclick' event of the option box I would probably try something like
>
> > > if me.checkbox.value = -1 then me.Form.Recordset = "tblclients"
>
> > > "Duck" wrote:
> > > > I have a form that is used to display patient records.  It's default
> > > > Recordset is set to a query which shows only current clients.  I want
> > > > to use an option box on the form to force the form to use the client
> > > > table (tblClients) as it's source Recordset, which would display ALL
> > > > clients (past and present), not just current clients.  How do I
> > > > accomplish this?- Hide quoted text -
>
> > > - Show quoted text -
>
> > I tried that already and would get "Operation is not supported for
> > this type of object" error  My code is:
>
> > If Me.optAllOrCurrent.Value = 1 Then
> >     Me.Form.Recordset = "qryCurrentClients"
> > Else
> >     Me.Form.Recordset = "qryCurrentClientsAll"
> > End If
>
> > The optionbox can have a value of either 1 (default) or 2- Hide quoted text -
>
> - Show quoted text -

Using RecordSource instead of RecordSet solved the problem...Thank you
all very much