469,920 Members | 2,388 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,920 developers. It's quick & easy.

Problem with subform using group header in Access 2007

I'm using a subform linked to the main form by a bidder number field. In the subform, I added a group header and put the field LS in it so that it would list all records designated as Live first under a heading that says Live, and then all that are designated as Silent under a heading that says Silent. The subform works beautifully by itself, but when I put it in the main form, I get an error that says "Access can't find the field 'Live or Silent' referred to in your expression." When you click Ok, it displays the error over and over (I'm guessing for each match) until you finally get to the end. All the while I can see the data displayed exactly as I'd like behind the error message, until the last error when it removes it. If I remove the LS Header, or move the field from the LS header into the detail section, it works perfectly, but I don't want Live or Silent listed on each record. I would also note that this works perfectly in Access 2003. It just won't work in Access 2007, even when you convert to Access 2007 format. Any thoughts would be appreciated.
Jan 3 '08 #1
5 2958
NeoPa
32,231 Expert Mod 16PB
It sounds like this is to do with what data is available and how it's accessed in your form (including but not limited to the controls).
Sharing that information might enable us to help you some more.

What it's basically saying is that you're referring to something which is not in the list of data you have included.
Jan 4 '08 #2
I've discovered that if I create a query then point the subform to the query (which contains exactly the same info as the table) it will work fine. I just dislike having to create an additional object to deal with that's nothing more than a replica of a table. It's apparently just an Access 2007 thing. I'm really trying hard to like 2007, but opening 2003 yesterday was like coming home. Thanks for your help.
Jan 4 '08 #3
NeoPa
32,231 Expert Mod 16PB
No worries CindySue.
Most of us here won't even pick it up. Personally I wouldn't even use it if it came free.
Jan 4 '08 #4
Megalog
378 Expert 256MB
Sounds like a similar problem I've run into.. We use 2007 now exclusively, and I've had to take many subforms and just replace them with queries.

Cindy, have you used the new split form feature yet? I've run into alot of bugs with those, and am interested to see if anyone else has the same problems.
Jan 4 '08 #5
No, I haven't tried the split form yet. With all the issues, I'm not sure I want to. Even though I've used Access for years, I'm not a programmer, and don't really build all that many new databases each year, so when things don't work as expected it's really frustrating.
Jan 8 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Andante.in.Blue | last post: by
4 posts views Thread by MacDermott | last post: by
2 posts views Thread by Lyn | last post: by
2 posts views Thread by Gary T. | last post: by
7 posts views Thread by wwwords | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.