linking two fields in seperate box's

[ksawb]

I have a bunch of tables each one a question. In each table two fields.
Field 1 is the answer field 2 is the points for that answer. How can I set it
up that the points show in a text box next to the combo box. I'm teaching
myself so I don't know a lot of the terminology for this program.

 

[KARL DEWEY]

I have a bunch of tables each one a question.
You should not have a separate table per question. Use a separate record
for each question.
Use this in select statement --
SELECT QuestID, [Answer] & " - " & [Points], ....

 

[Jeff Boyce]

Duane H. has created a survey/questionnaire application that may serve as a
model for what you are doing...

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[ksawb]

Thanks but where would I put the formula. Should I make a Query for this?

You should not have a separate table per question. Use a separate record
for each question.
Use this in select statement --
SELECT QuestID, [Answer] & " - " & [Points], ....

--
KARL DEWEY
Build a little - Test a little

I have a bunch of tables each one a question. In each table two fields.
Field 1 is the answer field 2 is the points for that answer. How can I set it
up that the points show in a text box next to the combo box. I'm teaching
myself so I don't know a lot of the terminology for this program.

 

[KARL DEWEY]

Yes you need a query. I suggest that you follow the advice given by Jeff
Boyce.
--
KARL DEWEY
Build a little - Test a little

Thanks but where would I put the formula. Should I make a Query for this?

I have a bunch of tables each one a question.

You should not have a separate table per question. Use a separate record
for each question.

How can I set it up that the points show in a text box next to the combo box.

Use this in select statement --
SELECT QuestID, [Answer] & " - " & [Points], ....

--
KARL DEWEY
Build a little - Test a little

I have a bunch of tables each one a question. In each table two fields.
Field 1 is the answer field 2 is the points for that answer. How can I set it
up that the points show in a text box next to the combo box. I'm teaching
myself so I don't know a lot of the terminology for this program.