How To Change Form RecordSet
in [General]
|
Prev: How To Determine Database Home Directory
Next: Is it possible to snd SMS's in a group from an access appl.? *
From: Duck on 4 Jul 2008 09:18 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?
From: scubadiver on 4 Jul 2008 09:32 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? > > > >
From: Duck on 4 Jul 2008 10:09 On Jul 4, 6:32 am, scubadiver <scubadi...(a)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
From: a a r o n . k e m p f on 4 Jul 2008 11:17 you want to be using RecordSOURCE not recordSET On Jul 4, 7:09 am, Duck <charles.kendri...(a)charter.net> wrote: > On Jul 4, 6:32 am, scubadiver <scubadi...(a)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
From: Duck on 4 Jul 2008 11:47
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...(a)gmail.com> wrote: > you want to be using RecordSOURCE not recordSET > > On Jul 4, 7:09 am, Duck <charles.kendri...(a)charter.net> wrote: > > > > > On Jul 4, 6:32 am, scubadiver <scubadi...(a)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 |