By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,453 Members | 3,225 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,453 IT Pros & Developers. It's quick & easy.

Problem with subform using group header in Access 2007

P: 52
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
Share this Question
Share on Google+
5 Replies

Expert Mod 15k+
P: 31,494
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

P: 52
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

Expert Mod 15k+
P: 31,494
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

Expert 100+
P: 378
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

P: 52
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.