Continuous form displays duplication of records

[Rehnahvah]

Hello Forum,

I have a continuous form based on a query with fields from a single table. There are a bunch of unbound fields in the header and footer, but the Detail section displays all of the records from the query.

My problem is this: When the form displays the records, it displays duplicates of the records (i.e., only 2 records in the table, but the form displays 4 records...2 of each record). I checked the query, and the query only returns two records.

Since this form is based on values from only one table, I changed the RecordSource for the form to the table, instead of the query, and that solved the problem of the duplicate display.

I envision having other forms that will display queried values from multiple tables. So while my immediate problem is solved, my wanderings have uncovered a problem I expect to have down the road.

I would appreciate any insight into why the form has double vision.

Thanks in advance!
Rehnahvah

 

[RuralGuy]

A plain query of a table should look exactly like the table. However, if you add a join to another table to your query then depending on the type of join you can get what appears to be duplicate records.

 

[boblarson]

A plain query of a table should look exactly like the table. However, if you add a join to another table to your query then depending on the type of join you can get what appears to be duplicate records.

Or if you add another table to the query and do not provide a join...

 

[Rehnahvah]

Thanks guys, that clears that up! I had an unrelated junction table in the query. (Don't ask me why )

 

[boblarson]

Thanks guys, that clears that up! I had an unrelated junction table in the query. (Don't ask me why )

WHY?

Call me michievous, but I just HAD to do that because you explicitly said "Don't ask..."