Form shows doubled records!!!

[registan]

Hello everyone,

Form's records are different from Record Source query records, why is that? Thank you.

 

[Gasman]

You are not using the source you think you are?

 

[registan]

You are not using the source you think you are?

What do you mean?

 

[registan]

 

[Gasman]

What I said. The source cannot change unless you ask it to/make it, but your question is hard to answer as you have not given anyone anything to work with.?
Upload the DB with the errant form and sources that populate it or instructions on how to replicate.

 

[registan]

What I said. The source cannot change unless you ask it to/make it, but your question is hard to answer as you have not given anyone anything to work with.?
Upload the DB with the errant form and sources that populate it or instructions on how to replicate.

The form name is: FrmPrihodSub
Record source query name is: QryPrihodSub

 

[Gasman]

Sadly my version cannot process your DB too well. I can run the query for the mainform, but not the subform.
You will have to wait for another member, sorry.

 

[Gasman]

Crossposted at https://www.utteraccess.com/topics/2059077/posts/2761284

 

[mike60smart]

The form name is: FrmPrihodSub
Record source query name is: QryPrihodSub

Hi
Your Main problem is that you are using Lookup Fields in your Tables
You should NOT use Lookup fields in tables. Google the "Evils of Lookup fields in Access Tables"

 

[theDBguy]

The form name is: FrmPrihodSub
Record source query name is: QryPrihodSub

Hi. I don't understand your concern. I opened the form and the query separately and see the same number of records for each.

 

[mike60smart]

Hi You are trying to filter the subform for the records that contain the value "ЧАЙ ЗЕЛ 25ф\ПАК 1,5ГР(24ПАЧ=0,9кг) Тёмная пачка"

But the subform is linked with Master/Child on the following ID 5789

This will only display 2 Records vice the 5 that contain the required value

 

[mike60smart]

Forgot to attache the Db

 

[registan]

Hi
Your Main problem is that you are using Lookup Fields in your Tables
You should NOT use Lookup fields in tables. Google the "Evils of Lookup fields in Access Tables"

Thank you!

Now I will delete Lookup fields one by one ))

 

[registan]

Hi. I don't understand your concern. I opened the form and the query separately and see the same number of records for each.

Yes, you are right. The total is right. But when you try to filter on record the problem happens.

 

[arnelgp]

i don't see any problem.
your form frmPrihodsub has Master/Child Link Fields, therefore there is already a Filter on it (idFa).
when you filter it again using the column, the filter is applied, the idFa + theColumn you filter.