Recent content by Nick Toye

So when I do that, it prompts me for information that I have put in for user interaction. For example, my query asks me for a beginning date and end date, and a customer name. If you read my previous posts you can understand my predicament. It doesn't behave like a form.

Can anyone tell me how to update a query from a form, Once i've done that I think we can put this string to bed, as thats all the help i'll think that i'll need for now. Thanks very much

Is it in the SQL View?

Sorry I didn't mean to confuse anyone, I just thought that my question had become relevant to forms so I put in that forum. My mistake. I think that i'm nearly there now, i've learnt quite alot about access. I just don't understand how I update the query.

What does that mean?

Ok, sorry about multiple posts, Anyway, that seemed to get rid of the error message, but how do I update the query recordset for the form. Thanks for your patience

I'm really sorry, you have to tell me like i'm a six year old because I'm having real trouble. Whats the vba sub? Where do I enter [event procedure]?

Ok, i'll give that a go.

How do I update the query?

How do I update the table that the form is based on. The fields for price remain at zero. I have been informed that this is because it is bound. I need to be able to print off the various delivery notes within a certain date span as one invoice, but the calculated figures don't show up...

Well i get the following error. "The expression BeforeUpdate you entered as the event property setting produced the following error: The object doesn't contain the Automation object 'Me.'."

What does Me. mean, what does it refer to exactly, sorry i'm a real beginner at database work. Thanks for your help so far.

Where do i put it on the query? The function I use is: =GetCost([Zone],[Weight]) My Module that I use is: Function GetCost(ByVal intZone As Integer, ByVal intWeight As Integer) As Currency If IsNull(intZone) Then GetCost = 0 Exit Function End If If...

Well where do I store the price, it doesn't show in the table, it only shows on the form, but I want the calculated price to be displayed in the table and the query so I can print it off when I want to. There must be a way

Well basically I need to generate an invoice based on all the delivery notes I enter into the form. I have the query set up so I can choose the customer I need to invoice and I can choose the dates, but when I view the report it shows all the delivery notes in the dates I specify but the value...