Search results for query: *

Perfect, works wonderfully. Thanks so much Ginger.

I'm having a small problem.. When calling the function after selecting a service. I get a compile error: User-defined type not defined And the top line is in yellow; 'Function GetRate(CompanyID, ContractorID, ServiceID)' and this line is highlighted: 'rs As DAO.Recordset'

Wow thanks so much Ginger, I'll give this a shot, and see how it goes. Aceman: Company, Contractor, and Service should only have ONE record per combination. I'll see how ginger's suggestion works out, thanks for the reply though.

Then it'll be a unique circumstance and the rate can be entered manually. Currently, we have a table on paper which lists each company, each service, and then the rate to charge each at. So, there should be a service for all pairings of contractor and company. Otherwise, the rates table will...

Oops, forgot a table. Services_tbl ServiceID Service Unit Type

The Company, Contractor and Service options are all in different tables. So..on the form, the companyid is looked up from its own table. Then, the contractor is selected from his own table. And the service from its own, so each selection is independant of one another. Here's the table list...

Thanks for the quick response, and unfortunately, that's only a small piece. The rate column should also be defined by the selection in the contractor and company drop-down boxes which are located in the form.

I'm having trouble implementing this in an invoice. Basically, I am trying to select a: 1. Company 2. Contractor 3. Service And have the rate automatically updated in the invoice_details subform. The Company and Contractor are located in the invoice form. The Service, Quantity, and Rate are...

Ah, okay. I should've caught that invoicedetailsid one. Thanks for the tips, I'll give them a shot and see how it works out.

Here's the situation. Each contractor has different rates for each company, and usually they stay the same, but they occasionally change over time, so it'd be nice if i could change that later without affecting previously issued invoices. How can I create a database design that when creating a...