G
Guest
Hi everyone. Using A02 on XP. Opening a form using the current form's field
[TPA Contact ID] and opening form "TPA-Address-Form" that has the field
[TPA-ContactID].
Grabbed my wordage below to use it but remembered it was a text field and
these are both number fields and they require more quotation marks.
Can someone help? I know it's simple. Just need extra quotes.
Also wasn't sure if I had the fields in the right position. Don't know the
translation of the line stLinkCriteria = "[TPA-ContactID]=" & "'" &
Me![TPA Contact ID] & "'" Which one is the current form field and which one
is the 'form to be opened' field?
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "TPA-Address-Form"
stLinkCriteria = "[TPA-ContactID]=" & "'" & Me![TPA Contact ID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Thank you to each and everyone of you that takes the time to help others
learn.
[TPA Contact ID] and opening form "TPA-Address-Form" that has the field
[TPA-ContactID].
Grabbed my wordage below to use it but remembered it was a text field and
these are both number fields and they require more quotation marks.
Can someone help? I know it's simple. Just need extra quotes.
Also wasn't sure if I had the fields in the right position. Don't know the
translation of the line stLinkCriteria = "[TPA-ContactID]=" & "'" &
Me![TPA Contact ID] & "'" Which one is the current form field and which one
is the 'form to be opened' field?
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "TPA-Address-Form"
stLinkCriteria = "[TPA-ContactID]=" & "'" & Me![TPA Contact ID] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Thank you to each and everyone of you that takes the time to help others
learn.