Goofy Form Problem

[Golfinray]

I have four forms, Manager A, B, C, and D. The forms are there so that our
managers can enter data such as when a new construction form comes in they
enter it on the form. B, C, and D work fine. The A form you cannot enter
anything. I have checked and unchecked every control on the form and rebuilt
the form a dozen times. The tables are reasonably normalized and the queries
work like a charm. This is driving up the wall. Any suggestions? Thanks!

 

[Klatuu]

Are you sure Allow Additions and Allow Edits for the form are set to Yes?
Are you sure your queries create an updatable recordset?

 

[Golfinray]

I know the allow additions and edits are set to yes. How do I see if my query
creates an updatable recordset? Is there some query property that has to be
set for that?

 

[Klatuu]

No, there is no property for that. If you open a datasheet view of your form
and see if there is a blank record at the bottom then the recordset is
updatable. If there is no blank line, it is not. Some queries create
recordsets that can't be updated. For example, Union queries, Totals
queries, and some with complex joins can't be updated.

 

[Golfinray]

I checked the form (actually a form and subform) both have blank records at
the bottom. The queries are plain jane select queries. Anyway, I just rebuilt
the form again and it is allowing additions and edits. Weird huh? Thanks so
much for your help! golfinray

 

[Klatuu]

**** happens.

I am right now working on a similar problem. Some of my forms that were
working correctly started having problems like not being able to set focus to
a control and not being able to set a bookmark.