Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OpenARgs continuous form help

Status
Not open for further replies.

Dre313

Technical User
Jun 4, 2003
219
US
A friend of mines helped my out on some code.. but he gave me only 3 fields to work with.. what i'm trying to do is.. on my form it pulls up records.. to that record.. you can add sub-records.. i took 3 unique fields of the original record and made a button to transfer those 3 fields to my new form..

come to find out.. i need to import more than three fields over to new form.. I need 12! YikEs! I only have 3 and my friends nowhere to be found..

I did seek help through this forum with other problems I had.. hope this is an easy one for the gurus out there.. thanks a bunch

heres the code which transfer 3



code:--------------------------------------------------------------------------------
Private Sub Form_Open(Cancel As Integer)
Dim strProject As String
Dim strArea As String
Dim strReference As String
Dim Iloc1 As Integer
Dim iLoc2 As String
Dim strArgs As String
'Dim Text1, Text2, Text3 As String

strArgs = Me.OpenArgs & ""

If Len(strArgs) > 0 Then
Iloc1 = InStr(strArgs, ";")
If Iloc1 > 0 Then
strProject = Left$(strArgs, Iloc1 - 1)
Me.strProject = strProject
iLoc2 = InStr(Iloc1 + 1, strArgs, ";")
strArea = Mid$(strArgs, Iloc1 + 1, iLoc2 - Iloc1 - 1)
Me.strArea = strArea
strReference = Mid$(strArgs, iLoc2 + 1)
Me.strReference = strReference
End If
End If
End Sub
--------------------------------------------------------------------------------




thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top