I want to create an interface for people to look at answers to pre-written questions.

[zzzjoshzzz]

I'm pretty new to Access and have been searching for a while to find this:
I have a set of, let's say, 300 pieces of data.
Each piece of data has a Question, and Answer to that Question, and what Topic that Question is related to.
I need to do two things:
1) Create some sort of interface where a user can click a topic and then select a question and see an answer


and
2) Have the user be able to submit a new Question and Answer and have them be able to select the Topic that they think it goes in (Bonus points if there's a good way to keep track of what was recently added and also points if they can create a new Topic)

If it isn't spelled out, I'll still appreciate it and try to figure it out but I'd prefer you remember my amateur status!
=)

[June7]

All that is possible but you need a good grasp of relational database principles, Access functionality, and maybe even programming concepts along with understanding macros and/or VBA.

An interface for user to enter criteria and then view related info means applying filter to recordset.

Keeping track of what was recently added means creating records. Creating a new Topic is also creating record(s).

[zzzjoshzzz]

All that is possible but you need a good grasp of relational database principles, Access functionality, and maybe even programming concepts along with understanding macros and/or VBA.

An interface for user to enter criteria and then view related info means applying filter to recordset.

Keeping track of what was recently added means creating records. Creating a new Topic is also creating record(s).

So I need to find a way to apply filters to recordsets using dropdown menus. I have a small amount of programming background and I know basic theory behind relational database - I just am not familiar enough with Access yet.

Thanks for the reply though! I'll try to work off what you posted.

[June7]

Look at tutorials in http://www.datapigtechnologies.com/AccessMain.htm especially the ones about filtering.

Also: http://allenbrowne.com/ser-62code.html

[zzzjoshzzz]

So I've struggled throughout the day and I've got a lot of what I need. I have a combobox that limits the selections of another combobox. My last step for now is to have a text box that shows the answer when I've selected the Question after selecting the topic. My problem is that I can't use "Row Source" with text boxes. Any ideas?

EDIT: I'm trying to use DLookUp but having troubles writing up the exact code and where to put it.

[June7]

Are question and answer in the same record in same table?

The question combobox can be multi-column. One of the columns can be the answer. This column can be hidden or visible. An expression in textbox ControlSource can reference the answer column by index. Index begins with 0. So if the answer is in column 2:

=[comboboxname].Column(1)

See the DataPig link for a tutorial on multi-column combobox.

[zzzjoshzzz]

Are question and answer in the same record in same table?

The question combobox can be multi-column. One of the columns can be the answer. This column can be hidden or visible. An expression in textbox ControlSource can reference the answer column by index. Index begins with 0. So if the answer is in column 2:

=[comboboxname].Column(1)

See the DataPig link for a tutorial on multi-column combobox.

Thanks! That did it!

One last thing and I'm done with the form:

Is there an easy way to code a button so that a user can suggest a new Question/Answer Set or a new Topic/Category?

It can't go directly in the database though, I'd need to be able to approve it.

[June7]

Why not put in the same table? Have a field for "Approved" (user need not ever see this field). The combobox RowSource query can be filtered to include only the approved questions.

Have the button open a form for user to input the new topic/category. The Approved field can default to No. Then you just need to review all the records that are not yet approved.