Hi all,

I have created my database for managing quotes but am now having a problem with the report.

I have created it the same as my forms (main form, with a sub form for selecting the items), but in this report, the item column is displaying the item ID number instead of the text.

Any ideas??

Glenn

Not enough info...

Are you trying to interact with the report, i.e. making selections, etc?

Reports are normally static ...

Ok... I have 3 tables...

tblPartsList - this contains a list of all the parts, part numbers, and prices
tblQuote - this contains the quote ID, quote name, contact, adress etc
tblQuoteSubform - this looksup the items from the tblPartsList and allows entry for quantity etc. It also has the QuoteID as the foreign key linking to tblQuote.

I also have a query, qryQuote, using all of the fields from tblQuote. On the ID number field thou', I have set it so the user has to enter the quote number, thus returning just 1 record.

The main rptQuote is using the control source qryQuote, and the subreport is using the control source tblQuoteSubform.

Sounds like the textbox in the subreport has the wrong control source - ?

Its looking at the right control source...
I have even tried it with adding a new text box and setting that control source to Item, and still that returns the items id number, instead of the item.

If 'item' is the name of the field you want and you put that in as the control source and you still get the contents of the 'item id' field then you must have something crossed up in the query...

The query doesn't select the item... The query selects the quote, and then the items are taken out of the table by the one-to-many link.

Its identical to the setup in the form, and that shows the text.

Any way you can post the db? Unless somebody else has a suggestion I'm a bit lost on this one...

Any ideas how to attach it on here??

Where you post your messages click the 'Go Advanced' button and there is a 'Manage Attachments' button you click to upload files. Not sure whatthe current size on an .mdb file is. Also I'm using Access 2003...

Have attached database...

What is the field 'Item' supposed to represent? I see you have a autonumber primary key and the part number. Is it supposed to be something like the keyword for the part number?

The field 'Item' is the item name...

For example;

Item: Tester Kit
Part no: ABC123

Only about 70% of our items will have a part number.

Got 'cha... Give me a minute to look at it...

You are storing the item id in the item field when you do the combo box selection in the form. You want to fix that or you want meto give it a shot?

Ok without sounding dumb, i wasn't aware that it could save that value...

Could you possibly make the correction??

In the sub form, for the item combo box change the bound column to 2 instead of 1 and see if that fixes it for new items you add.

Well... would you look at that...

Change the bound column and all seems to be working now.

Thanks very much for your help. Really appreciate it. :)

Cool glad to help and glad you have it working :)