David McAfee
davidmcafee at gmail.com
Thu Mar 8 13:18:45 CST 2012
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> >