Consulting

Results 1 to 3 of 3

Thread: [Access] Help for assigning checkbox to a recordset value?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    [Access] Help for assigning checkbox to a recordset value?

    Private Sub Command13_Click()
    Dim abc as string
     
    abc = Combo10.Value
    
    
    
    forms!abc.Check1 = rst![name]    ‘assign check1 to one recordset  checkbox
    DoCmd.OpenForm abc, acNormal
     
    End Sub

    This command 13 button will open a form according to the combo10.value which the user chooses. I have many different forms’ names assigned to combo10.

    There is an error when I run the above code because the forms!abc.check1 has an error.
    This is because access cannot read the different forms names under abc.

    Is there another way for forms!abc.Check1 to work when the forms names under abc will change?

    Thanks.
    Last edited by spidermman; 11-04-2008 at 10:22 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •