Unloadable fields and unchangeable sub-form 1

[taubate]

I have 2 problems with Access forms that I need help on:

1) The form fields on one form just doesn't show up when the form is loaded. I checked the properties of each field (e.g. lock, enable, etc.) and they seem correct.

2) On another form, a sub-form is supposed to allow data changes, but it doesn't (ie I can't type new data or select a new value). Again, the properties seem to be okay.

Can anyone shed any light? Thanks!

 

[JoeMiller]

1) There is no data in the source query feeding your form. If there's no data, access shows nothing on the form, no controls or anything.

2) Verify that the query feeding your subform can have data added to it. Go into the query by itself (forget the form for now). If you can't add data directly there then you have some join in your query that is not allowing data to be added. Reduce the complexity of your query and try again.

HTH Joe Miller
joe.miller@flotech.net

 

[taubate]

Thanks!