Changed Form Source to Query to Sort Data and Getting Errors

  • Thread starter Thread starter Karl Burrows
  • Start date Start date
K

Karl Burrows

I tried to change the sort order of a form to using a query and now any
records that have no data are locked and I am unable to input any data in
the fields. I just created a query that matched the field values of the
table I was using before and changed the source of the form to the new
query.

Did I do something wrong here? Do I need a different type of query or
anything in the query to tell it to add new data?

Thanks!
 
Actually after looking at it a bit more, it does not let me add any new
records to any groups, not just new ones. We have a main form with regional
information and then a sub-form with the detail within that division. I
can't add to a division that had no data to start with (just division info
setup initially) or add records to any existing division.

Thanks!

I tried to change the sort order of a form to using a query and now any
records that have no data are locked and I am unable to input any data in
the fields. I just created a query that matched the field values of the
table I was using before and changed the source of the form to the new
query.

Did I do something wrong here? Do I need a different type of query or
anything in the query to tell it to add new data?

Thanks!
 
are you using a query as the RecordSource of the main form? or the subform?
or both? post the SQL from the relevant query(s).
 
I am sorting the records in the subform only because I changed a field value
to text (you just posted to that question as well, thanks!), which resulted
in using a query instead of a direct link from the tables to populate the
information in the form.

I removed the query and created another one and it is working now. I guess
I must have had a missing field or had some constraint that was keeping the
form from populating.

Thanks!

are you using a query as the RecordSource of the main form? or the subform?
or both? post the SQL from the relevant query(s).
 
Back
Top