Automatically create records

[Access Virgin]

first i would look at my attachment to see my table structure and relationships.

there are 20 questions in tblQuestion, i want the user to open a form, enter the caseno, click a button and a subform (control source = tblMain) will poulate with the 20 questions. then my users can add their answers.

this all sounds so simple yet i havent a clue on how to go about doing this, would i need to use a query?

i hope i have made my problem clear, does anyone have any advice or solutions?

 

[Rich]

Fizzio posted a similar problem here earlier this year, unless he wakes up and points to the thread, you'll have to search for it sadly. Search by user name

 

[Fizzio]

Yawn........Ok what's for breakfast. Oh damn, slept in again.
Here is the post I think Rich is referring to (but I never really know what he is talking about mind you)

Get back to me if it helps (or not)

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47792&highlight=relationship

 

[Rich]

(but I never really know what he is talking about mind you)

That's 'cause Geordies don't speak proper English

 

[Fizzio]

That's 'cause Geordies don't speak proper English

Nowt to do with speaking, everything to do with listening and understanding - of which you obviously do not