C
Chris Malley
I started a database using the Membership template found on the office online
site
(http://office.microsoft.com/en-us/templates/results.aspx?qu=membership&sc=4&av=ZAC). I added two tables, Sessions and Instruction Rates.
The Sessions database has information about various program sessions
including the number of registrants for each member type. It also includes a
lookup field to identify the group of rates for that session from the
InstructionRates table. This is the same type of lookup provided in the
Members table with the MemberType table.
When the Members form is used to create or modify a member the Member Dues
field is updated when the Member Type is updated and the value is updated in
the field in the Members table. I want the corresponding rates fields in the
Sessions form and table to be updated when I update the InstructionRatesID
field in the sessions form.
The database does not use a query, but does use visual basic for an Event
Procedure for the After Update.
The following code is used in the Members form:
Private Sub MemberTypeID_AfterUpdate()
Me![MemberDues] = Me![MemberTypeID].Column(2)
End Sub
The following code is used in the Sessions form:
Private Sub InstructionRateID_AfterUpdate()
Me![I1] = Me![InstructionRateID].Column(3)
Me![I2] = Me![InstructionRateID].Column(4)
Me![F1] = Me![InstructionRateID].Column(5)
Me![F2] = Me![InstructionRateID].Column(6)
End Sub
When I update the InstructionRatesID field in the form, the various rates
field are updated with blank values rather than the values in the
InstructionRates table.
The plan is to use the Sessions table to automate invoicing for the facility
that I bill.
Any help is appreciated.
site
(http://office.microsoft.com/en-us/templates/results.aspx?qu=membership&sc=4&av=ZAC). I added two tables, Sessions and Instruction Rates.
The Sessions database has information about various program sessions
including the number of registrants for each member type. It also includes a
lookup field to identify the group of rates for that session from the
InstructionRates table. This is the same type of lookup provided in the
Members table with the MemberType table.
When the Members form is used to create or modify a member the Member Dues
field is updated when the Member Type is updated and the value is updated in
the field in the Members table. I want the corresponding rates fields in the
Sessions form and table to be updated when I update the InstructionRatesID
field in the sessions form.
The database does not use a query, but does use visual basic for an Event
Procedure for the After Update.
The following code is used in the Members form:
Private Sub MemberTypeID_AfterUpdate()
Me![MemberDues] = Me![MemberTypeID].Column(2)
End Sub
The following code is used in the Sessions form:
Private Sub InstructionRateID_AfterUpdate()
Me![I1] = Me![InstructionRateID].Column(3)
Me![I2] = Me![InstructionRateID].Column(4)
Me![F1] = Me![InstructionRateID].Column(5)
Me![F2] = Me![InstructionRateID].Column(6)
End Sub
When I update the InstructionRatesID field in the form, the various rates
field are updated with blank values rather than the values in the
InstructionRates table.
The plan is to use the Sessions table to automate invoicing for the facility
that I bill.
Any help is appreciated.