Why can't I add records in a form?????

[csunsun]

in the form properties i have allowed additions. when i open the form the new record button is all gray and cannot be pressed.

this is a main form with a subform attached.

any ideas? i wonder what is causing this!

THANK YOU

 

[wuzzel]

Hi C,

I hope you already tried opening the form's recordsource, and see if you can add a record in that query. There's a range of reasons or causes for querys to be read-only or not-appendable, and the form will always 'know', even if you don't.

Greetings, Daan

 

[csunsun]

ok, i get it. on my record source query i am summing up records. so is there a way to add records to a form that pulls summed up data?

thanks very much!