Question Duplicate in Report but not in Form!!!!!

[vid]

Hi!

something very weird is happening in my db.

I have 2 fields Product Code, Product Name such that when i enter the value of either one, the value of the other one appears on its own from the Products table.

I have 2 entries in the product table, both with product name = name2, And product code=code2, code21.

Something very weird is happening in my db. When i choose either one of these in the product code section and try to get a printout of it by clicking on "Printable Page" (which generates a report), The report opens up, but has records for both the products even though i've entered only one in the form.

I have created a sample of my database and uploading it. Please someone have a look at it and help!!!

My company has product names and codes like this which i cannot change! i have no clue what to do

 

[gemma-the-husky]

i think if you print the form, you get all the records from the underlying query - not just those visible.

maybe you need to modfiy the query

===========
in any event, yuou are gnerally better designing a report, to print out. - not printing a form.

 

[vid]

Well that's why I'm using the report for printing. I tried playin around with the query its based on but I can't figure out why this is happening.. Please have a look at it if possible! thanks