how do i create a subform?

  • Thread starter Thread starter reservedbcreater
  • Start date Start date
R

reservedbcreater

just make a form and in code specify that it is another form's subform???

i have no clue? please tell me how?
 
It's much easier than that. Create a form that will be the subFrom, save and
close it. Create another form that will be the parent. With the parent open
in design view, drag the subFrom from the forms list and drop it on the
parent form.

TomU
 
Have you taken the time to look over the sample database (Northwinds) that
comes with Access.

You need to look at that and try to learn how it works. There are reports
and forms that contain subreports and subforms. If you look over this and
learn how it works, it may answer a bunch of the questions you are posting
here.

If you still have issues, you may want to think about hiring a consultant to
help you. Many of your posts lead one to believe that your data structure
is badly flawed. Until you step back and fix the structure of the database,
you will not be able to fix the end results easily.

If I remeber correctly, you have a survey database where you boke it into 17
pieces and used 17 tables. Does that mean that each table contains one of
the questions? Does each table have a key that ties them together? In
other words, if "John" fills out a survey, does "John" have one record in
each of the 17 tables?

You may want to consider using the "At Your Survey" database that one of the
Access MVPs built. It has a lot of cool features and will probably handle
everything you need to do.

Rick B
 
man im only a 20 year old college work stundet hired for $15/hr to create a
huge DB and interface for this company for an 8 mnoth work term throguh
school.......i have no training in access...only vb.net, java, sql, and a
1 yr business certificate

i am finding that they are asking way to much but they are telling me to
just do what i can
 
yes each table ahs ID key
and each table has about 20 questions or more on a different subject per
form
 
oh and Rick B, where is the "At Your Survey" database that one of
the
Access MVPs built????????/
 
here is a recent post that mentions it...

----------------------------------------------------------------------------
--------
Yes. In fact, our own Duane Hookom created one called "At Your Survey" that
might do the trick for you. You can find a copy here:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane


--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
reserveddbcreater, did you get that book I mentioned? Please believe
me that all your questions could be answered by taking the time to
read this book. You will probably pickup some neat tips to aid you in
designing the database.
 
Back
Top