Form/Subform Question

[TotallyConfused]

I am working with a Main form and subform. However, as I was making changes.
I noticed that on my subform the fields with checkboxes are locked. You
can't uncheck or check the checkboxes. This was working fine. I tried
retracing my steps by going back to find the problem but can't seem to get
this to work. Any help will be greatly appreciated. Thank you.

 

[TotallyConfused]

Okay I did find the problem. None of my fields can be accessed. I am
working on an old db that was based solely on a flat file. I took the flat
file and normalized by breaking it down into several tables I joined new
tables and used a query for this Form/subform. How do I make this work. the
Form/subform is for tracking, data entry and making changes. Any help will
be greatly appreciated. Thank you.

 

[John W. Vinson]

Okay I did find the problem. None of my fields can be accessed. I am
working on an old db that was based solely on a flat file. I took the flat
file and normalized by breaking it down into several tables I joined new
tables and used a query for this Form/subform. How do I make this work. the
Form/subform is for tracking, data entry and making changes. Any help will
be greatly appreciated. Thank you.

Are you trying to use a multitable query for one or other of the forms?
Instead try using a Form for the "one" side table of the relationship, and one
or more Subforms for the "many" side tables. Some multitable queries are
updateable, some aren't, but trying to update a multitable query is more
complex than needed at best.