Recent content by HeatherE

No, still doesnt' seem to be working. Maybe I'm doing something wrong here? I thought it would be an easy problem to fix, but I can't seem to get the value to stay once I reload the form. Does anyone have anything else I can try?

I've tried to do that, but it won't stay in the box after I close the form and open it again. The value is still in the Default Value in the properties box, but the value doesn't appear in the form. Any ideas?

I'm currently using the Order Entry DB and am having a problem setting a default value for the EmployeeID field in the frmOrders. The user only has one employee that sells tickets and would like to be able to have that employee's name automatically appear in the combo box each time she enters...

Thanks for the fix! If I had only searched the archives, I would have realized the problem...

I'm currently using a DLookup for a form so that the user can't enter a duplicate customer record. Normally it works fine, but when I try to enter in a name with an apostrophe (i.e., O'Neill or O'Donnell), I get an error message. Can anyone help me with this? Here's the code I'm using...

So how would I create a query that would only total the freight charge for the time period selected by the user?

No, right now the Freight Charge is only listed as a total on the report. The report is a Summary report of all sales made within a specific period that the user designates. The report is titled “Sales by Product” and only lists the products and units sold for the period designated; it doesn’t...

I didn't see an answer to Topher's question; I'm having the same sort of problem with a report that I'm designing. Right now I have the total for the freight charge on the report as a DSum total. But, when I run the report it gives me the total freight charges to date rather than just the...