Results 1 to 2 of 2
  1. #1
    New Lounger Ensemble's Avatar
    Join Date
    Apr 2013
    Location
    Centurion
    Posts
    23
    Thanks
    9
    Thanked 1 Time in 1 Post

    Parent - Child influence on coding

    I have a form with the following getfocus event:

    DoCmd.OpenForm "frmLineInfo", acNormal, , "[idsLineID] = " & Me.idsLineID, , acDialog

    This works fine and performs precicely as I expect.

    However when my form is used as a sub form, I get the following error:

    Run-time error '3075'
    Syntax error (missing operator) in query expression '[idsLineID] = '.

    The form will always be used as a sub form.

    How do I fix this?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,538
    Thanks
    0
    Thanked 23 Times in 23 Posts
    Were you trying to open the form frmLineInfo as a subform?

    Does the subform have the Master/Child links set?

Posting Permissions

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