Let me preface my question by stating that I do not like Microsoft Office
2007 at all.

With that being said, here is my question...

I have a form that I need to add a record source to. I have tried using a
table and a query, but when I try to save it, it won't save any of my fields
that I have added. I've also had this happen in a report. Why won't it save
and is there anything I can do to make it save?

"save it" save what? The form? A form doesn't have "fields", it has controls
that can be bound to fields. If you enter values into bound controls, the
default behaviour is to save the entered value in a record in the table/query
that is the Record Source of the form.

Are your controls bound to fields from your form's record source?

--
Duane Hookom
Microsoft Access MVP


"augrl02" wrote:

> Let me preface my question by stating that I do not like Microsoft Office
> 2007 at all.
>
> With that being said, here is my question...
>
> I have a form that I need to add a record source to. I have tried using a
> table and a query, but when I try to save it, it won't save any of my fields
> that I have added. I've also had this happen in a report. Why won't it save
> and is there anything I can do to make it save?