View Single Post
  #1 (permalink)  
Old March 9th, 2011, 06:04 AM
Srez Srez is offline
Registered User
Join Date: Mar 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access Forms - Sub Forms Controls


Issue - Unable to choose a different values (status) for each record in a subform

Business Hierarchy
I have a list of Cases.
Each case can have multiple Loans.
Each loan has multiple attributes.
Attributes can have 'Original' value and 'Updated' Value

Form Hierarchy

Form 1 - Lists all the cases
Form 2 - (A bound sub form, continuous form view) - This form correctly lists all loans corresponding to the Case selected in from 1 (Driven by the On Current Event of Form 1).

I have added unbound combobox control (to specify status of a loan) in the subform that is repeated for each loan in the Form 2, by virtue of the Continuous form. When I select a value from the combo box against Loan 1, the same value for the combo box is repeated for all Loans in the sub form

I want to assign a different status for each loan in the subform using the combo box.

Is this possible at all.

Reply With Quote