Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

Subform asking for Parameter Value

access 2000
win 2000 sp4

I have a checkbox that I'am using to try and change the master and child  link fields.
But I keep getting a Box asking for a parameter value.


' code ---------------------------------------------------------------
Private Sub Check3_Click()
       Forms!frmSearch![data1 SUBFORM].SourceObject = "Data1 Subform"
        Forms!frmSearch![data1 SUBFORM].LinkMasterFields = [Text13]
        Forms!frmSearch![data1 SUBFORM].LinkChildFields = [MFRNUM]


Any suggestions?
Thanks
fordraiders
0
Fordraiders
Asked:
Fordraiders
1 Solution
 
peter57rCommented:
Hello fordraiders,

I've never done this but I would assume that the values you assign must be strings.
So my first guess would be:

Forms!frmSearch![data1 SUBFORM].SourceObject = "Data1 Subform"
Forms!frmSearch![data1 SUBFORM].LinkMasterFields = "[Text13]"
Forms!frmSearch![data1 SUBFORM].LinkChildFields = "[MFRNUM]"







Pete
0
 
FordraidersAuthor Commented:
ah !!!
Correct, basic stuff....
Appreciate the awakening....
Thanks
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now