Hello I have to add two extra columns to my look up table StateCategory and StateServicesCovered
Right now if the users pick a code from the MER Code drop down box, it populates 2 to 3 fields, now I have to add two more columns. Here is what I have so far
Code:
Private Sub MERCodes_AfterUpdate()
Me.Catagory_for_hours = Me.MERCodes.Column(2)
Me.Catagory_for_hours.SetFocus
Me.Catagory_for_hours.Dropdown
Me.Services_Covered = Me.MERCodes.Column(3)
Me.Services_Covered.SetFocus
Me.Services_Covered.Dropdown
Me.NameofWorkshop = Me.MERCodes.Column(4)
Me.NameofWorkshop.SetFocus
Me.NameofWorkshop.Dropdown
Me.MERCodes.SetFocus
End Sub
This is the Code I put in but I'm getting an error message Saying "compiler error - method or data member not found".
Code:
Private Sub MERCodes_AfterUpdate()
Me.Catagory_for_hours = Me.MERCodes.Column(2)
Me.Catagory_for_hours.SetFocus
Me.Catagory_for_hours.Dropdown
Me.Services_Covered = Me.MERCodes.Column(3)
Me.Services_Covered.SetFocus
Me.Services_Covered.Dropdown
Me.NameofWorkshop = Me.MERCodes.Column(4)
Me.NameofWorkshop.SetFocus
Me.NameofWorkshop.Dropdown
Me.StateCategory = Me.MERCodes.Column(5)
Me.StateCategory.SetFocus
Me.StateCategory.Dropdown
Me.StateServicesCovered = Me.MERCodes.Column(6)
Me.StateServicesCovered.SetFocus
Me.StateServicesCovered.Dropdown
Me.MERCodes.SetFocus
End Sub
Not sure what I'm doing wrong? Can anyone help please??
this is my lookup table
Code:
SELECT ServicesCovered, CategoryForHours, Codes, CodeID, ID, NameOfWorkshop, StateCategory, StateServicesCovered, EventName, EventLocation
FROM dbo.ServCategorylookup_tbl
it updates this table
Code:
SELECT ID, [Parent ID], ServicesCovered, StateCatagory, StateServicesCovered, Catagoryforhours, EventName, NameofWorkshop
FROM dbo.TanfActivity_tbl
dBforums
>
Cascading combo box error
02-08-12, 17:22
Linear Mode
