条件格式帮助。 [英] Conditional format help.

问题描述

我正在为发票建立另一个数据库。我有两张桌子用于发票，一张用于零件。


发票表包含几个字段。对于客户信息和要存储的订单。


零件表包含字段

part＃

Serial ＃

描述

价格


我为发票创建的表格，我希望对部件信息进行有条件的格式化例如：


当从连接到零件表的下拉框中选择零件＃001时，它会自动将序列描述和价格填入表格中的相应字段。然后，我想要将价格字段乘以数量字段乘以总数。进入总场。然后是底部的子总数。


如果有人可以帮我怎么做，那将非常感激。哦，是的，我正在运行MS ACCESS 2000.如果需要任何进一步的信息，请告诉我。


非常感谢

I am building another data base for invoices. I have two tables on is for the invoices, one is for the parts.

The invoice table contains several fields. for the customer info and for the orders to be stored in.

The Part table consists of fields
part #
Serial #
description
Price

The form that I created for the invoice, i want to have conditional formatiing for the part info for example:

When part # 001 is selected from the drop down box that is connected to the part table then it automatically fills in the serial description and price into the appropriate fields on the form. I then want the price field multiplied multiplied by the quanity field to bring a total. into the total field. Then a sub total at the bottom.

If anyone can help me with how to do this it would be greatly appreciate. Oh yeah I am running with MS ACCESS 2000. If any further info is needed let me know.

Thanks a lot

推荐答案

您可以将文本框的控件源设置为DLookup相应的字段。

You could just set the control source of the textboxes to DLookup the appropriate fields.

您可以将文本框的控制源设置为DLookup相应的字段。

You could just set the control source of the textboxes to DLookup the appropriate fields.

但它会自动查找信息。它们是不同的字段？

But would it automatically look up the info. They are different fields?

但它会自动查找信息。他们是不同的领域？

But would it automatically look up the info. They are different fields?

只要你的组合框发生变化就会自动查找，因为控制源会与组合框的值绑定。

It would automatically lookup whenever your combobox changes because the control source would be tied to the value of the combobox.

这篇关于条件格式帮助。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！