Adding result box next to drop down menu

[ashu.doc]

Hello everyone
I am a newbie for access, I am trying to add a result box which will contain number chosen from a dropdown menu, so it will be something which look like this:


LABEL ''drop down menu'' '' result box''

In the drop down menu there will be different criterias (text) and each criteria will have specific number. What I want to do is when the user select one of the criteria (which will be in the form of text), the number assigned to that criteria comes into the result box next to it. Sorry for being so demanding I don't know how can I assign number to those criterias.

Many Thanks
Ash

[jzwp11]

Welcome to the forum!

Is the drop down menu based on a table or are you supplying the values through a value list? I would recommend putting the various criteria as records in a table and use the autonumber field in that table to assign a unique number to each criteria. Then base your dropdown on that table. Include the autonumber field as well as the text field in the dropdown. Access will automatically use the autonumber field as the bound field of the dropdown. If you want to show that ID value in another textbox you can use an expression to reference it. That expression would be =comboboxname.column(0) (assuming that the ID field is the first field in the combo box's row source;Access starts counting at 0 not 1).

[ashu.doc]

Welcome to the forum!

Is the drop down menu based on a table or are you supplying the values through a value list? I would recommend putting the various criteria as records in a table and use the autonumber field in that table to assign a unique number to each criteria. Then base your dropdown on that table. Include the autonumber field as well as the text field in the dropdown. Access will automatically use the autonumber field as the bound field of the dropdown. If you want to show that ID value in another textbox you can use an expression to reference it. That expression would be =comboboxname.column(0) (assuming that the ID field is the first field in the combo box's row source;Access starts counting at 0 not 1).

hi there
its working perfectly
cheers

[jzwp11]

You're welcome.

[ashu.doc]

Another quick one - if I am trying to show the sum value of the different text boxes which I have created with expression builder with this expression -

total = [1]+[2]+[4]

its showing the value 124 rather than 7 ??

[jzwp11]

Access is interpreting the value as a string/text. Make sure to set the format of the textboxes to a number (general number or fixed etc.). If you still have an issue you could force the value to be a number using the applicable conversion function such as cLng([textbox1name])+cLng([textbox2name])+...

[ashu.doc]

Access is interpreting the value as a string/text. Make sure to set the format of the textboxes to a number (general number or fixed etc.). If you still have an issue you could force the value to be a number using the applicable conversion function such as cLng([textbox1name])+cLng([textbox2name])+...

you are a champ
thanks

[jzwp11]

You're welcome; glad it worked out for you.

[ashu.doc]

You're welcome; glad it worked out for you.

Hi there
There is a little glitch, I have calculated the final value of my formula which I was using in a form, but what I want is actually is to save this value which comes after calculation from this formula to be saved in database. The value is called mortality rate which is coming in a text box, since I have already given a formula (1/(1+e^(-x))) for "control source" to this box, I am not able to save it in a table.

[jzwp11]

In general, calculated values are not stored in a database but rather calculated on the fly when you need them in forms, queries or reports. You would only store the raw values needed to do the calculation.

[ashu.doc]

In general, calculated values are not stored in a database but rather calculated on the fly when you need them in forms, queries or reports. You would only store the raw values needed to do the calculation.

ok, so clearly what I can do is calculate the value in another page and write the values manually in the main form if i want to save them.
Thanks

[jzwp11]

You should not save the calculated value. What would happen if one of the values used in the calculation changes? Your value that you manually entered would no longer be correct. It is best to calculated the value when you need it. In a main form you can reference a query that calculates the value via a Dlookup() function

[ashu.doc]

You should not save the calculated value. What would happen if one of the values used in the calculation changes? Your value that you manually entered would no longer be correct. It is best to calculated the value when you need it. In a main form you can reference a query that calculates the value via a Dlookup() function

Hi again
I have a major issue with my database(which is actually a surgical logbook). First I created tables - personal details(doctor's details who is using the logbook), patient details, and operation details. And after that I created forms corresponding to tables. I have taken hospital ID of patient as primary key, which I have put in all tables as separate field. What I dont understand is if the user enter the data in these three forms for one patient ID, how is it possible that one set of data gets created itself under one hospital ID with all these different forms.
Basically I am asking that how to interconnect all three forms and all three tables together as one set for one patient ID.

Thanks in advance

[jzwp11]

Can you post your relationship diagram so that I can see how you created your relationships?

[ashu.doc]

hi this is the relationship