MS Access Question

Littleroger · 7 Feb 2009 at 17:56

Hi

I'm struggling with a problem that i have in access and would appreciate any help. basically I'm doing a form which is part of a questionnaire. for 1 of the questions to make it easier the answer is 1-5 but they mean a long description.

what i need is on the After Update property i need it to show what the answer it is by having the number. thanks for any help, i no its difficult to understand I'm just not sure how to word this lol.

thanks anyway
Roger

Dolph · 7 Feb 2009 at 18:19

If you want to do it as an afterupdate, the case statement is your friend.

Is it a combo box/list box you are using? if so, populate it from a table and include the question ID, then set the bound column to the question ID to save the number instead of the long answer for insertion into the main table. This would probably be the better way of doing it.

Littleroger · 7 Feb 2009 at 19:03

thanks for the fast reply.

i only want it to save the answer to the question as a number but i want it to show it what the answer actually is when looking on the form.

is there any tutorial that i could look at

Dolph · 7 Feb 2009 at 19:08

Have a look here for info on combo boxes.

http://www.databasedev.co.uk/ms_access_combo_box.html

It also contains an example to do exactly what you want, either as a fixed list or via a table.

Littleroger · 7 Feb 2009 at 19:11

thanks a lot that is exactly what i was looking for!

Dolph · 7 Feb 2009 at 19:17

No worries, happy to help