Forms from queries

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

Originally, I set up my database so that all the forms and
subforms were created directly from the tables but, I was
having major problems printing. It was suggested to me
that I should create queries instead and make all my
forms/subforms tie into those queries. I have done that
but, now all my checkboxes are greyed out and when you try
to enter a check an error message pops up saying "You
can't assign a value to this field". Any idea how to fix
this?

Also, one of my queries is too big and will not work with
the form (too many fields defined). I tried making each
subform connect to a query with only the fields needed and
then I tried to make the main form connect to a query
containing records from the main table (including the rec.
no.) and the id from each of the other tables but, it
doesn't allow me to add any new records. Is there any way
to do this also?
 
I'm not sure what you mean by this - how would I do a
proper normalization of the tables? What will it do?

Thanks!
 
Back
Top