Report showing duplicate record

[cwwaicw311]

Hi,

I uses a combo box in my form to open a report to show the record of the item choose. However, the record in my report is duplicating as the number of data i have enter into my table

For example I have 3 different record in my table Item A Item B n Item C

So the current output of my report should be showing Item A oni when Item A is choose for the combo box in my form



But now it showing 3 Item A in my report. And it is the same when i choose Item C n Item B

Help... URgent...!!!

[pbaldy]

It sounds like the report is based on a query with an incorrect (or no) join. What is the SQL of the query?

[maximus]

I am attaching the mdb let me know if this solves your problem. Changed report arranged by trasaction ID makes more senses that way.

[maximus]

Were you able to solve your problem.

[maximus]

Mark This thread solved too. The problem is that the list Box is displaying the details of Taged trasaction. so it will only display the stock level of the trasaction ID. so now tell me what do you want exactly.
This is what I will do for you:
1) List Box will show the taged entry and stock level on that particulat transaction.
2) A text Box will show the current stock Level.

anyways marrk this thread solved too.

[cwwaicw311]

Hi,

Regarding the balance in the listbox, I just want it to show the latest balance after the item reach the minimun level.

U say the textbox to show the currentstock level how it will show the stock level if there r 2 item in the listbox...??

Thank...

[maximus]

I have Included a TextBox on the main menu form that will always reflect the current sctock of an enventory selected. Check it out.

[maximus]

is your problem solved.

[cwwaicw311]

Hi,

Yup problem solved, i use the textbox and modifiy the database a little...

Thank

[maximus]

so as of today the case is closed my brother. Glad could help you out.

[cwwaicw311]

Attached is the file which got problem regarding the form name cannot be locate in either macro or visual basic code

[maximus]

Convert it into access 2000 format and then send itto me.

[cwwaicw311]

attached is 2000 format

[maximus]

You have changed the name of the startup from please go to startup properties and reselect the main_menu form again it will csolve your problem.