Advice on populating an unbound form
Posted on 2012-03-21
I've developed two access form that use an underlying view from an sql server backend. Basically, this view displays a pivoted view of the data. The main form is a continuous form where each record is populated from the aforementioned view. Each record has a detail button which when clicked, is used to display a detailed version of the record in single form view. Everything is working fine. However, management wants to be able to change data via the main form (in continuos view) However since this data is aggregatted data, the only way I can think of to do this is to make this form an unbound form and to populate it via ado. However, I don't think there is a way to assign data to an unbound continuous form. I think that the only way to make changes to the data would be via making the detail form an unbound form and to populate that form which is in single form view via ado. Are there any other alternatives?