jwcolby
jwcolby at colbyconsulting.com
Thu Mar 8 13:33:42 CST 2012
> What does read only have to do with it? > All of these are read only. OK, let me rephrase that, SPs work great of the forms are read-only, but these are data entry subforms. SPs return read-only recordsets. This whole thread is about binding updateable forms to ADO recordsets. I already use SPs to display read-only data and they work great for that. John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 3/8/2012 2:18 PM, David McAfee wrote: > What does read only have to do with it? > > I have a screen that has a datasheet which is bound (I know, right? Kill > me) to a view. > > It lists a bunch of machines. > > The on current event of the subform populates a couple of hidden fields on > the parent form. > The other subforms on the parent form are all updated as the user moves > from record to records. > > I have one that displays the machine information (Model, SN, Model > description, customer where it is located, Company Rep) > Another diplays the warranty info (in/out, start date, end date, warranty > type...) > A list box on the bottom displays the machine's history. > Another listbox shows the customer history > Yet another shows the SalesRep history. > > All of these are read only. > > D > > On Thu, Mar 8, 2012 at 11:04 AM, jwcolby<jwcolby at colbyconsulting.com>wrote: > >> AFAIK they can't because they are read-only. I WISH! >> >> >> John W. Colby >> Colby Consulting >> >> Reality is what refuses to go away >> when you do not believe in it >> >> On 3/8/2012 1:42 PM, David McAfee wrote: >> >>> Stored procedures can do this. (Warning Aircode:) >>> >>> me.sbfrmDiary.recordsource = "stpDiaryRecord "& me.parentID >>> me.sbfrmExpenses.recordsource = "stpExpensesByParentID "& me.parentID >>> >>> >>> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd> >> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com> >>