[AccessD] quick help needed

Sorry...I guess more info would be in order...I'm just sweatin' a little over this.
 
The record source for this report is a query ("qryCertInfo"). This query is based on two other queries...the first being a table of "county information" ("qryCntyInfo") and the 2nd ("qryCert2Print") which is based off the current record that is up on the entry form. This form based query chooses its single record from "[Forms]![frmDataEntry]![ssn]" on the form, and, "[forms]![frmDataEntry]![sfrmCerts].[Form]![Certificate Date]" on that form's sub-form.
 
As I am typing this, I'm wondering if I may not have found my own solution...might it be because there is yet to be any data on the subform? There is nothing in, "[forms]![frmDataEntry]![sfrmCerts].[Form]![Certificate Date]", so maybe it is fudgin' up things.
 
BUT...why does it work sometimes? If this is the case, it shouldn't work at all.
 
...NEVERMIND...I found it! It IS what I just described. For some reason, she was forgetting to enter a certification date, and the program was choking on that. So, I showed her what the problem was...and now I have to add something to check for this.
 
Thanks for the help...sometimes I just need to talk it out w/someone. It tends to scare those around me, w/I talk amongst myself ;o)

>>> Gary Kjos <garykjos at gmail.com> 6/17/2010 11:11 AM >>>
Well what is the record source for the report?  Is it using a filter
of some kind when you call the report from the form to select that
same record for the report?  That would seem to be where to focus.
Perhaps a dubug mode session to see what is in fields used for the
filter?

GK

On Thu, Jun 17, 2010 at 9:56 AM, John Clark
<John.Clark at niagaracounty.com> wrote:
> I just rolled out a new program yesterday and it worked quite well. I tested it and ran it through the course, and everything seemed to go as planned. I am fully aware that no matter how much you test something, as soon as you turn it over to the user(s), they WILL find the bugs, and I warned them that this will happen and we'll work through anything that comes up...it is easy w/this group, because they literally sit right beneath my office...we share a server, a switch, everything is the same, so I can basically mimic everything they do.
>
> Well, it was installed yesterday. After installing it, I watched as the user entered her first bit of information. It was pretty uneventful, but we did get a bug...my fault actually, as I borrowed some new code that I liked for my nav buttons and I wasn't really comfortable w/it...that was bad enough, but this actually made some previously entered code buggy as well. All in all though, nothing huge and I just had some little bugs to fix. And, they had some customers come in throughout the day, and all went well.
>
> BUT...after I left for the day, they got another customer and the program would not cooperate. Basically, this program takes in student information and prints a certificate that they take to their schools. This certificate, which printed previously, no longer found information off the form. It prints, but it is blank where any information from the form goes...it prints from the current form. Now it says, "Run-time error '3021' No Current record."  And, that is not all the time...what they hey?! There IS a current record...it is the one on the screen that I am pushing the button for!
>
> Any clues here would be greatly appreciated...I'm a bit under the gun here.
>
> Thanks!
>
> John Clark
>
>