访问报告不断重复上次记录。 [英] Access Report keeps repeating last record.

问题描述

我有一个表单，用户可以选择我用作过滤器的值来为它们填充报表。该报告后面有VB代码，因此它可以是用户选择的所有不同过滤器的动态。出于某种原因，当用户选择多个贷方（或报表上的列）时，它会正确填充报表，然后反复重复上一条记录。我完全迷失了为什么这样做。它工作起初很好，但现在（可能在我做了一些我不记得的改变之后）它无法正常工作。


这是很多代码所以如果任何人都有兴趣看看它只是让我知道，我会发布代码。


谢谢

I have a form where the user selects values that I use as filters to populate a report for them. The report has VB code behind it so that it can be dynamic to all the different filters that the user selects. For some reason, when the user selects more than one lender (or column when on the report), it populates the report correctly but then repeats the last record over and over. I''m completely lost as to why it is doing this. It worked in the begining fine, but now (probably after I made some change that I can''t remember) it is not working correctly.

It is a lot of code so if anyone is interested in looking at it just let me know and I''ll post the code.

Thanks

推荐答案

我有一个表单，用户选择我用作过滤器的值来填充报表。该报告后面有VB代码，因此它可以是用户选择的所有不同过滤器的动态。出于某种原因，当用户选择多个贷方（或报表上的列）时，它会正确填充报表，然后反复重复上一条记录。我完全迷失了为什么这样做。它工作起初很好，但现在（可能在我做了一些我不记得的改变之后）它无法正常工作。


这是很多代码所以如果任何人都有兴趣看看它只是告诉我，我会发布代码。


谢谢

I have a form where the user selects values that I use as filters to populate a report for them. The report has VB code behind it so that it can be dynamic to all the different filters that the user selects. For some reason, when the user selects more than one lender (or column when on the report), it populates the report correctly but then repeats the last record over and over. I''m completely lost as to why it is doing this. It worked in the begining fine, but now (probably after I made some change that I can''t remember) it is not working correctly.

It is a lot of code so if anyone is interested in looking at it just let me know and I''ll post the code.

Thanks

你''我需要发布相关代码供任何人查明正在发生的事情。


从用于过滤报告的代码开始。还提供用于查询的sql作为报告的记录源。

You''ll need to post the relevant code for anyone to work out what''s going on.

Start with the code used to filter the report. Also provide the sql for the query being used as the record source of the report.

您需要发布相关代码任何人都可以知道发生了什么。


从用于过滤报告的代码开始。还提供用于查询的sql作为报告的记录源。

You''ll need to post the relevant code for anyone to work out what''s going on.

Start with the code used to filter the report. Also provide the sql for the query being used as the record source of the report.

由于某种原因，它不允许我发布代码。说我的消息需要超过20个字符，但它的方式不止于此。

For some reason its not letting me post code. Says my message needs to be longer than 20 characters, but its way more than that.

出于某种原因，它不允许我发布代码。说我的消息需要超过20个字符，但它的方式不止于此。

For some reason its not letting me post code. Says my message needs to be longer than 20 characters, but its way more than that.

我不知道问题是什么。您是否在代码上添加了标签？

I''m not sure what the problem is. Are you putting tags on your code?

这篇关于访问报告不断重复上次记录。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！