[AccessD] Bind forms to ADO recordset

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>
>


More information about the AccessD mailing list