Linking Combobox back to table

[jzwp11]

What determines whether Y is worth 1 point or 2 points?



If you are using an option group you can set the value of each response, so why not set the options values to the actual points?

...I would like the 3 to appear in text574

I'm not sure what you mean by the "3" in this.

[jlclark4]

I had to set that database aside and go back to the one I was working on.

With the one from before, I am trying to be able to search by a person (which this person has multiple entries) and it brings up a list of all the entries dealing with that person. I assume this needs relationships built between the list of names and the main table correct? Also, how do I get this to work? I have the initial window set up where you either click add new record or search records. I would like the search records to be different then the form that comes up with new record. Someone types in for example my name: Jennifer; and all the records that I have entered pop up in a box below. Then they can select which record they want to work on ... click, and the form that normally would open (the one with all the data in it) pops up for that corresponding entry... how can I do this? If I can get some hints, I should be able to figure it out...

[jlclark4]

[QUOTE=jzwp11;42820]What determines whether Y is worth 1 point or 2 points? [QUOTE]

Depending on the question. I found a way to do it, I think it is the long way but it gets the job done. I used code to calcuate quality point for each question, then an expression to get the percentange. I think I am going to use the tab option to put all the questions into categories...that is once i get the other database finished up!

[jzwp11]

Concentrating on the following:

Someone types in for example my name: Jennifer; and all the records that I have entered pop up in a box below. Then they can select which record they want to work on ... click, and the form that normally would open (the one with all the data in it) pops up for that corresponding entry... how can I do this?

I would first recommend using a continuous subform with a button the user can click to select a specific record (you can use the command button wizard option to open the form to a specific record).


I would present the user with an unbound combo box with the names (such as yours). Then I would base the subform on a query that references that combo box. When someone selects a value from the combo box, requery the subform. In the subform's record source, you must include the key field for the data item that will be displayed in the form that will open upon the user's button click event.

[jlclark4]

Here is a sample...

[jzwp11]

Here is your sample with modification.

[jlclark4]

Thanks I really wish I was working in 2007. 2003 is giving me a headache.

[jzwp11]

You're welcome. I didn't have too many issues with Access 2003; in fact, I still use it at work.