Some subforms work some don't

[Mark Annett]

I just ran the migration assistant with no errors on my 2003 database. I
only converted and linked the tables.

In my database, I make extensive use of subforms, with master/child
relationships. Can anybody tell me some reasons why some of my subforms
would work (i.e. I can add new records) and others wouldn't?

In my front-end, I can't see any difference between the ones that work and
the ones that don't. It doesn't seem to make sense.

Does anybody have any suggestions on what I should be checking?

--
Mark Annett
ISPManSys.com

[Gina Whipp]

Mark,

Can you edit the recordSource of your subforms? I am sure that is where the
problems lie.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Mark Annett" <MarkA...@discussions.microsoft.com> wrote in message
news:4861A6A5-3EA0-416A...@microsoft.com...

[Mark Annett]

Thanks Gina,

I just tested rebuilding some of the queries for some of my subforms,
without changing anything else and now they work.

It made no sense. I guess when I rebuild the query it re-establishes
everything. I am glad that was all I needed to do. Hopefully the rest of
the conversion wil be that easy. :)

Thanks for the help.

-Mark-
--
Mark Annett
ISPManSys.com

"Gina Whipp" wrote:

> .
>

[Gina Whipp]

Mark,

No problem... I had it happen to me and I still don't know why, glad that
tip came in handy!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Mark Annett" <MarkA...@discussions.microsoft.com> wrote in message

news:72136A47-91CF-40E7...@microsoft.com...