recordsource "mcnewsxp" <mcourter[ at ]mindspring.com> 04.08.2006 17:56:11 i need to store a forms recordsource in a variable. when i use me.recordsource i get a SQL statement. the form is bound to a table - not a stored proc or view. ?

Re: recordsource PBsoft <info[ at ]REMOVEpbsoft.it> 07.08.2006 13:42:15 [Quoted Text] > i need to store a forms recordsource in a variable. Ok. > when i use me.recordsource i get a SQL statement. Right. > the form is bound to a table - not a stored proc or view. Ok. > ? What's the matter? -- PBsoft di Gabriele Bertolucci www.pbsoft.it skype: pbsoftsolution

Re: recordsource "mcnewsxp" <mcourter[ at ]mindspring.com> 07.08.2006 15:04:12 [Quoted Text] >> i need to store a forms recordsource in a variable. > > Ok. > >> when i use me.recordsource i get a SQL statement. > > Right. > >> the form is bound to a table - not a stored proc or view. > > Ok. > >> ? > > What's the matter? > instead of strRecordSource = "SELECT * FROM dbo.whatever...." i need strRecordSource = "dbo.whatever"

Re: recordsource "Vadim Rapp" <vr[ at ]myrealbox.nospam.com> 08.08.2006 01:50:25 m> instead of strRecordSource = "SELECT * FROM dbo.whatever...." m> i need strRecordSource = "dbo.whatever" yourvariable = split(strrecordsource,"SELECT * FROM ")(1) Vadim Rapp