Recent content by Elhan

Okay now the sum function works on the subform. Now., say I want to link this field to one on the main form (or a report). How do I do this? Altering the control source alone doesn't seem to work. :confused:

OK the problem is the data view form allows you to add many records easily and view them...does the form view method allow you to add multiple records as well?

Anyone? :(

Hmm so what should I do now? If I redesign the form and base it on queries how will I get the combo boxes to make changes on the subform and the form itself? I want the subform to have a cost combo box which allows costs to be selected and the main form to have a combo box allowing patients to...

Eeek no :eek: lol I had changed the design from a form based on queries to a form based on tables due to the fact that I couldn't attach working combo boxes to the subform or the main form. Now you're saying I have to go back to a query based form so I can make a calculate sum field...

Hmm the subform's footer or the form's footer? I tried both and it still generates an error message. Could someone have a look at the form itself to see?

Ok umm it works, but the problem is for one item only :S It doesn't add all the items up to give a total cost. :confused: Please... I really need to get this thing working :(

Hi, I want to sum a calculated field on one of my forms. The field is calculated by multiplying the cost of a good by its quantity. So far I have been unable to sum it. Does anyone know how I can do this? Here is a link to what the field is related to just so you people know what I am talking...

Hmm the subform is meant to allow the user to select costs from a list (the combo box) and add them on. It is thus used for cost selection. You choose a cost (say medication) and add it to the subform. The subform is primarily made up from the Costs table. As such, you are correct. The subform...

Hmm yes a patient can have multiple treatments. Generally the cost of the treatment is always the same. The patient only gets a 5% discount if their account is above £250 and a 10% if they are not insured. Have you managed to determine yet what the problem is?

Okay I compressed it as you said and I am adding it as an attachment here. Thanks for the tip :) a) A patient may only have one insurance agency at a time, but one agency may have many patients. The Patient/ Insurance Agency table is part of the normalisation process...perhaps the type of...

Okay Peter sent you two files. What is your email account's max storage capacity btw? The one is about 1000 kb, the other a little more. Vengsiva I checked my subform for those properties and it appears they aren't there. Keep in mind I generated the form using a form wizard. Its based on two...

Ok I will send you the file in two versions...one not compressed and one slightly compressed. I will send them via my email elh4n2005@yahoo.com :) Hopefully you will be able to see what is the error. I removed any unnecessary data. Its still a large file :S With the cost combo box I want the...

Thanks!!! Sent it :) Ok Vengsiva I tried what you told me and managed to get the combo box to allow you to select patients. Yet it still has no effect on the form. I trust the subform's combo box would work in a similar manner. Problem is I don't know how to set the childsfield and linksfield...

Row Source: SELECT qryPatient_Treatment.PatientID, qryPatient_Treatment.[Patient Name], qryPatient_Treatment.[Patient Surname] FROM qryPatient_Treatment; (I tried changing patient_treatment.patientID to patient_treatment.[patientID] but this makes no change) Column Count: 3 Column Width...