var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Where condition - Access can't find teh field etc
I hope someone can help on this one....
I need to open a report with only one record.
I can do this usually, but I think I have mucked this one up by using a subform.
I am using the following to set the where condition:
stWhere = "[SlipIDNo] = " & "'" & Me.[AchievementEntryFormSub]![SlipIDBox] & "'"
Every time I include this, I get an error message sayng that Access can't find the field "|". So I can only assume that I have got it wrong on how to refer from the sub form.
Could someone give me a nudge in the correct direction on this one please before I go totally nutz?!
Assuming the name of your subform is spelled correctly, try this:
stWhere = "[SlipIDNo] = " & "'" & Me.[AchievementEntryFormSub].Form![SlipIDBox] & "'"
Also, is SlipIDNo a number? If so then you don't need the "'" around the Me.[AchievementEntryFormSub].Form![SlipIDBox]. Just put:
stWhere = "[SlipIDNo] = " Me.[AchievementEntryFormSub].Form![SlipIDBox]
I hate the syntax for referring to subforms... I am still confused by it.
Thanks a 1000 times. Who'd have thought a couple of quotes could have been such bother. It was the number thing after all.