making an invoice

  • Thread starter Thread starter SD Diamond
  • Start date Start date
S

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
 
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
 
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
Click to expand...


.
Click to expand...
 
Back
Top