Queries to create forms not working like it should

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

Guest

Instead of using Tables to create forms was told to make smaller tables and
use queries to coralate data into quieres for each form I wanted to create.
Did that and the forms come out in design view with each haveing its own
field list from a created query.

My New problem is this , I can creat the forms and I can see the
fields and I can enter data into those fields but they are still stand alone,
the Queries are not cross-updateing the other reports with the same fields
pulled from the exact same small table I created for just those items
relevent to all form.
And, some of the forms Im creating are not allowing data to be saved to
that form, any suggestions on what Im doing wrong?
 
I rarely use more than one table as the record source of a form. You can use
subforms to enter records into related tables.
 
JimmyD said:
Instead of using Tables to create forms was told to make smaller tables and
use queries to coralate data into quieres for each form I wanted to create.
Did that and the forms come out in design view with each haveing its own
field list from a created query.

My New problem is this , I can creat the forms and I can see the
fields and I can enter data into those fields but they are still stand alone,
the Queries are not cross-updateing the other reports with the same fields
pulled from the exact same small table I created for just those items
relevent to all form.
And, some of the forms Im creating are not allowing data to be saved to
that form, any suggestions on what Im doing wrong?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Learn the Access jargon. Tables/queries do not "create" forms - you
create forms. Queries to not "cross-update" reports, they act as
RecordSources for reports.

Queries do not automagically update all the columns in joined tables
unless you either enter the data manually, or run an UPDATE or INSERT
query to enter the data.

Solution:

Instead of using multi-table queries as Form Recordsources, use single
table queries and subforms. Subforms hold the data for dependent
tables. Subform's are linked by Child/Master Link Field properties.
When you enter data into a subform the Child/Master Link Field
automatically enters the Parent (Master) form's data into the Child's
linking fields. You have to enter the rest of the Child's data in the
subform.

Read the Access Help articles on subforms (Contents hierarchy in Access
2002 Help file):

Forms
Creating subforms
About subforms - see "Synchronizing a form and a subform" at the
bottom of the article.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQjexwIechKqOuFEgEQIxqwCdHr9NYpl8vT01Cvl/g3prK7fxVaoAniTm
EaATOWrebfpr8XoN+uAA53cr
=WuVx
-----END PGP SIGNATURE-----
 
All of that sounds great , but that brings me back to my previous problem, I
had to create more tables, how many fields allowed in a query? If I could
make a single table that would be great, but I have over 800 seperate fields
no duplicate information, of those 800, 15 of those fields are ones that will
be used as same information pertaining to individual required on all 10
forms. and 50 differnt report types.
 
Back
Top