help with multiple forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a database to track client information. tbl1 has client demo (name, address, phone etc) clientID is the primary source and is an autonumber. tbl2 is a questionaire with about 20 questions and a completion date. tbl1 and 2 are linked have a 1 to many relationship.The questionaire is going to be done atleast 4 times for each client (questionaire should be completed every 3 months, so if a client is in the program for 1 year, the questionaire should be filled out 4 x's for that client.

what i want to do is have the main form with info from tbl1 and then a a command button (or something) that when pushed will bring up a subform with the questionaire for the current client. if the client has filled out a questionaire before, i want to be able to review it and if i need to fill out a new questionaire, i want the clientid in tbl2 to autofill with the current client. any help is greatly appreciated.

what are the page breaks for, i tried a page break but when i look at the form, you still see both forms. i was thinking about using a tab control, but the problem with that is that the questionaire is to long and it doesnt look right.
 
Dear Nydia

My suggestion would be to design your questionnaire
ensuring that you have the clientID field included as the
foreign key. Then go back to your main form and insert the
questionnaire form as subform in the detail area of the
form, linking the two together on the ClientID.

Hope this helps

Paul
-----Original Message-----
I'm creating a database to track client information.
Click to expand...
tbl1 has client demo (name, address, phone etc) clientID
is the primary source and is an autonumber. tbl2 is a
questionaire with about 20 questions and a completion
date. tbl1 and 2 are linked have a 1 to many
relationship.The questionaire is going to be done atleast
4 times for each client (questionaire should be completed
every 3 months, so if a client is in the program for 1
year, the questionaire should be filled out 4 x's for that
client.
what i want to do is have the main form with info from
Click to expand...
tbl1 and then a a command button (or something) that when
pushed will bring up a subform with the questionaire for
the current client. if the client has filled out a
questionaire before, i want to be able to review it and if
i need to fill out a new questionaire, i want the clientid
in tbl2 to autofill with the current client. any help is
greatly appreciated.
what are the page breaks for, i tried a page break but
Click to expand...
when i look at the form, you still see both forms. i was
thinking about using a tab control, but the problem with
that is that the questionaire is to long and it doesnt
look right.
 
Back
Top