Using A2K with SQL Server. I have a subform with a column that has uniqueidentifier data in it. I want to call a stored procedure passing this value but am having trouble getting the control value. Access does not recognize the control in code. Here is a clip of the code. The control ID_Group is not recognized.
Help!
vmon
Debug.Print Me.ID_Group.Value
Forms!frmEmailMaint!lstReports.RowSource = "EXEC procEmailMaintReportListBox '" & Me.ID_Group.Value & "'"
I found out a little more but still cannot get it working. I can debug.print the control value using StringFromGuid(see below). Problem is that the stored procedure above is not refreshing the list box. If I run stored proc and paste Guid at prompt for parameter it runs fine and show appropriate records. Just doesn't from form.
Help again,
vmon
Debug.Print StringFromGUID(Me.ID_Group) '{guid {FA321DA0-5B74-454D-B418-F986EFE524EE}}
Help!
vmon
Debug.Print Me.ID_Group.Value
Forms!frmEmailMaint!lstReports.RowSource = "EXEC procEmailMaintReportListBox '" & Me.ID_Group.Value & "'"
I found out a little more but still cannot get it working. I can debug.print the control value using StringFromGuid(see below). Problem is that the stored procedure above is not refreshing the list box. If I run stored proc and paste Guid at prompt for parameter it runs fine and show appropriate records. Just doesn't from form.
Help again,
vmon
Debug.Print StringFromGUID(Me.ID_Group) '{guid {FA321DA0-5B74-454D-B418-F986EFE524EE}}
Last edited:
