A
Agnelo Fernandes
I have a main form containing information of candidates coming for a
particular course. The information of candidates coming to course include
their name and address.
Now I have enabled a button 'payment details' in the main form. When I click
this button it opens up a new subform linked by that particular date. For Eg:
On Record 3: If the course date is 3/10/2008 and I have enlisted the names of
candidates for that day and I click the button 'payment details' on the main
form then I am taken to a new subform which contains the exact name of
candidates as recorded in 3/10/2008. Now this subform has 3 check boxes
[Invoice, Cross Charge, Cheque].
Based on the box I tick I should get the required details visible.
I tried the below code for Invoice check box:
Private Sub Invoice_AfterUpdate()
Me.Name.Visible = Invoice
End Sub
This worked. So, when I checked the Invoice checkbox the control 'Name'
appeared.
However, this event occured for all candidates in the subform which I dont
want to happen.
I want the controls to appear based on the checkbox (Invoice, Cross Charge,
Cheque) i tick independant for each candidate. So if I tick Invoice for
candidate A then associated controls should visible only for candidate A.
Similarly if I tick Cheque for candidate B then associated controls should be
visible only for candidate B while the other controls should be invisble.
Based on the above program - if I tick Invoice then the associated controls
are visible for all candidates - I need it to be visible independantly per
candidate
Any help?
particular course. The information of candidates coming to course include
their name and address.
Now I have enabled a button 'payment details' in the main form. When I click
this button it opens up a new subform linked by that particular date. For Eg:
On Record 3: If the course date is 3/10/2008 and I have enlisted the names of
candidates for that day and I click the button 'payment details' on the main
form then I am taken to a new subform which contains the exact name of
candidates as recorded in 3/10/2008. Now this subform has 3 check boxes
[Invoice, Cross Charge, Cheque].
Based on the box I tick I should get the required details visible.
I tried the below code for Invoice check box:
Private Sub Invoice_AfterUpdate()
Me.Name.Visible = Invoice
End Sub
This worked. So, when I checked the Invoice checkbox the control 'Name'
appeared.
However, this event occured for all candidates in the subform which I dont
want to happen.
I want the controls to appear based on the checkbox (Invoice, Cross Charge,
Cheque) i tick independant for each candidate. So if I tick Invoice for
candidate A then associated controls should visible only for candidate A.
Similarly if I tick Cheque for candidate B then associated controls should be
visible only for candidate B while the other controls should be invisble.
Based on the above program - if I tick Invoice then the associated controls
are visible for all candidates - I need it to be visible independantly per
candidate
Any help?