Search results

Thanks, that works great. Im sure I can figure this out, but is there a way to add what ever was typed into the field, to go directly into the look up table?

I have a form that is used to order office products. I would like the person who is entering the order to be able to type directly into the field, and once the item has been entered, it becomes an item listed in the combo box from that point on. Currently the user needs to go to a seperate...

I am trying to make a check box which when checked means completed and unchecked means pending. I would also like it to populate a completed date field with the current date. Thanks for the help....

Sorry the reason why i posted this in the query section is because I am basing both the form and report off the same query.

I need a report to print out from a form that combines like Items and then totals them. The report will not have the department field listed.... Here's an example: Form: Department---Product#---Type----Qty-Cost-- Total Accounting---------i123 ----pen---- 2-- 1.00-- 2.00...

I need a report to print out from a form that combines like Items and then totals them. The report will not have the department field listed.... Here's an example: Form: Department---Product#---Type----Qty-Cost-- Total Accounting---------i123 ----pen---- 2-- 1.00-- 2.00...

Thank you very much, that makes a lot of sense. I'll try to put it together now.....

I need to create a report that groups duplicates and totals the quantity. Here's an example: Current Report: Product# Type Qty Cost Total i123 pen 2 1.00 2.00 a987 paper 3 1.00 3.00 i123...