Opening Forms

  • Thread starter Kath via AccessMonster.com
  • Start date
K

Kath via AccessMonster.com

Hi all,
I am working on an application that is collecting indicators. The
relationship is PI Entry ID & Site ID & Time Period of Entry = Unique Key.
For each indicator, they will open a form and fill out specific information
on that indicator. I have a function that is supposed to be linking the
forms but is not working. Can anyone help me in what may be the issue?
Thanks..here is the code used.
-----------------------------------------
When they select the indicator via a drop down list:
-----------------------------------------
Private Sub openForm()
Dim pstrSQL As String
Dim pobjRS As ADODB.Recordset

Select Case Me.cboPI_ID
Case "ADM-1"
Call openTheForm("frmADM_1", "tblADM_1")
Case "CA-4"
Call openTheForm("frmCA_4", "tblCA_4")
End Select
End Sub
 
K

kathieglassel via AccessMonster.com

Also: the indicator forms all have this on the load event.

Private Sub Form_Load()
Dim pstrArgs As String
Dim paryArgs() As String

If Me.AllowAdditions And Me.AllowEdits Then
pstrArgs = Me.OpenArgs
paryArgs = Split(pstrArgs, ",")

Me.PI_E_ID = paryArgs(0)
Me.PI_SITE_ID = paryArgs(1)
End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top