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?
Subscribe to our Windows Secrets Newsletter - It's Free!
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?