VBA openform where clause

petebob796

Registered User.
Local time
Today, 13:14
Joined
Jul 31, 2007
Messages
27
im trying to run this:
DoCmd.openForm formName, , , [Attendance Sector]![School] = [Forms]![Explorer School]![School]

Attendance Sector being my forms data source table with field school being compared to the one on the form but it errors with [Attendance Sector] external name not defined. I know its probably something simple.
 
ok fixed usual thing I post then realise what I have done wrong straight after. Forgot my quotes.
 

Users who are viewing this thread

Back
Top Bottom