K
Konchetta via AccessMonster.com
Hello to you EXPERTS!!!
I am a self taught Access user who needs some additional assistance in
completing this creation for my Internal Audit Supervisor. Anyway, I have
read through many threads about Synchronizing Combo boxes but my data still
will not show in the second combo box. I dont think I'm fully understanding
the coding.
This is my database background: I have a table named Sub Grantee List which
shows all of our Sub-Grantee names(Field=Sub-Grantee Name) along with their
control number(Field=Control Number) and Federal Programs associated with it
(ANOTHER PROBLEM). In my Form I have two combo boxes, one for the Sub-
Grantee Name(Sub-Grantee Name1) and one for the Conrol Number(ControlNumber).
I want to be able to choose the Sub-Grantee Name from the first combo box(Sub-
Grantee Name1) and the Control Number for the Sub-Grantee populates the
second combo box. I know this is simple from all the threads I have read but
I can't get this to work. The Form is driven from Table named(Audit
Information) which includes the sub-grantee name and control number as well.
This is my coding for After Update of (Sub-Grantee Name1) Combo box:
Private Sub Sub_Grantee_Name1_AfterUpdate()
Me.ControlNumber.RowSource = "SELECT Sub_Grantee_List.Control_Number, Sub-
Grantee_List.Sub_Grantee_Name FROM" & _
" Sub_Grantee_List WHERE Sub_Grantee_List.Sub_Grantee_Name = " & Me.
Sub_Grantee_Name & _
" ORDER BY Sub_Grantee_Name"
Me.ControlNumber = Me.ControlNumber.ItemData(0)
End Sub
I have changed it around and around and now I'm T-Totally confused!! I do not
have a row source on my second combo box as indicated in other threads I have
read.
Can YOU, the EXPERTS please help out a desperate Auditor. Once this problem
is resolved I have yet another problem which I think involves List Boxes.
PROBLEM-Each Sub-Grantee can be associated with up to 4 of our Federal Awards.
I want to be able to choose those associated with the Sub-Grantee and for
those chosen to be shown on the Form. Is that doable!!! I currently have the
fields as Program #1, Program #2.....This seems to pose a problem when I want
a report for just one Program. Or it just may be my formatting of the report.
But to make this short, if you could please help me with my first issue and
I will try to figure out my second issue. I guess I can Synchronize those as
well huh??!!!
Any assistance will be truly appreciated!!!
Totally Confused
I am a self taught Access user who needs some additional assistance in
completing this creation for my Internal Audit Supervisor. Anyway, I have
read through many threads about Synchronizing Combo boxes but my data still
will not show in the second combo box. I dont think I'm fully understanding
the coding.
This is my database background: I have a table named Sub Grantee List which
shows all of our Sub-Grantee names(Field=Sub-Grantee Name) along with their
control number(Field=Control Number) and Federal Programs associated with it
(ANOTHER PROBLEM). In my Form I have two combo boxes, one for the Sub-
Grantee Name(Sub-Grantee Name1) and one for the Conrol Number(ControlNumber).
I want to be able to choose the Sub-Grantee Name from the first combo box(Sub-
Grantee Name1) and the Control Number for the Sub-Grantee populates the
second combo box. I know this is simple from all the threads I have read but
I can't get this to work. The Form is driven from Table named(Audit
Information) which includes the sub-grantee name and control number as well.
This is my coding for After Update of (Sub-Grantee Name1) Combo box:
Private Sub Sub_Grantee_Name1_AfterUpdate()
Me.ControlNumber.RowSource = "SELECT Sub_Grantee_List.Control_Number, Sub-
Grantee_List.Sub_Grantee_Name FROM" & _
" Sub_Grantee_List WHERE Sub_Grantee_List.Sub_Grantee_Name = " & Me.
Sub_Grantee_Name & _
" ORDER BY Sub_Grantee_Name"
Me.ControlNumber = Me.ControlNumber.ItemData(0)
End Sub
I have changed it around and around and now I'm T-Totally confused!! I do not
have a row source on my second combo box as indicated in other threads I have
read.
Can YOU, the EXPERTS please help out a desperate Auditor. Once this problem
is resolved I have yet another problem which I think involves List Boxes.
PROBLEM-Each Sub-Grantee can be associated with up to 4 of our Federal Awards.
I want to be able to choose those associated with the Sub-Grantee and for
those chosen to be shown on the Form. Is that doable!!! I currently have the
fields as Program #1, Program #2.....This seems to pose a problem when I want
a report for just one Program. Or it just may be my formatting of the report.
But to make this short, if you could please help me with my first issue and
I will try to figure out my second issue. I guess I can Synchronize those as
well huh??!!!
Any assistance will be truly appreciated!!!
Totally Confused