2014-03-28, 06:44 #1
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?
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2014-04-02, 08:08 #2
- Join Date
- Dec 2001
- Melbourne, Australia
- 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?