How to display a specific value from a table on the form

  • Thread starter Thread starter Erdogan
  • Start date Start date
E

Erdogan

I have two tables named as Questions and Answers. What I
wanted to do is to see the questions on the form while I
enter the answers from Answers form. I wrote a query and
tried with listbox to show the questions but the problem
is if the question is too long then I need to make the
listbox very long to see the whole question. I dont know
how to make multiple lines with listbox.
I tried with textbox but it didnot work since there is no
place to attach a query.

Thanks for your help..
 
create a query wich holds data from answers table and questions table
related to each other by a common id
now you can drag and drop the answer to your form, it will propably be a
combobox but you can change this by right clicking and using the change
to... option in the contextmenu

....or if you have/insert a subdatasheet in your table you can already check
if the relationship between the tables is set up correctly, if you choose
autoform in the menu you will automatically get the type of form I think
you're looking for

bon chance
 
Back
Top