making an invoice

[SD Diamond]

I have been trying to modify the Order Entry Template in
MS Access 2000 to build a DB that will work for our
company. The problem is that I cant's figure out how to
get multiple descriptive fields to become part of the
order details subform. It's a combo box that shows only
the ID number and I need it to show the cut, color and
clarity of the diamonds we sell.
Also - one that is modified how can I get the printable
invoice report to show those results?
Any info is helpful! Thanks!

SD Diamond

 

[Arvin Meyer]

Add the fields to the combo box and set the widths of the columns you don't
want/need to display, to 0. Then refer to the column you want to see in a
text box by setting it's control source to the combo's column (zero based)
like this:

=[Forms]![MyFormName]![MyComboName].Column(2)

which would display the 3rd column.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[SD Diamond]

Thank You - i will try that.

-----Original Message-----
Add the fields to the combo box and set the widths of the columns you don't
want/need to display, to 0. Then refer to the column you want to see in a
text box by setting it's control source to the combo's column (zero based)
like this:

=[Forms]![MyFormName]![MyComboName].Column(2)

which would display the 3rd column.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

I have been trying to modify the Order Entry Template in
MS Access 2000 to build a DB that will work for our
company. The problem is that I cant's figure out how to
get multiple descriptive fields to become part of the
order details subform. It's a combo box that shows only
the ID number and I need it to show the cut, color and
clarity of the diamonds we sell.
Also - one that is modified how can I get the printable
invoice report to show those results?
Any info is helpful! Thanks!

SD Diamond

.