ACCESS FORM INFO

[Guest]

I have a form created based on a query that when you go to open the form it
asks for an emp no, when you type in the emp num it populates fields with
info, the problem I am having is now it want let me add info to fields that I
added to the form. It stops at the field, but when I go to type, I can't
type. What have I done?

 

[Dirk Goldgar]

I have a form created based on a query that when you go to open the
form it asks for an emp no, when you type in the emp num it populates
fields with info, the problem I am having is now it want let me add
info to fields that I added to the form. It stops at the field, but
when I go to type, I can't type. What have I done?

Please post the SQL of the query. Did you change the query in some way?

Can you edit any of the fields on the form? Can you add a new record on
the form? Is it just these new fields you can't update? What are the
Control Source properties of the new controls?

Is there a message in the application's status bar when you try to type
in the new controls? If so, what is it?

 

[Guest]

No, I cannot edit any field and I don't get any message in the status bar.

 

[Dirk Goldgar]

No, I cannot edit any field and I don't get any message in the status
bar.

Then I suspect that you made a change to the query that rendered it
nonupdatable. I'll bet you can't add any records either, and if you
open the recordsource query directly in datasheet view, you'll probably
find that you can't update that. Please post the SQL of the query, and
explain what change you made to it.

You may want to review the help topic, "When can I update data from a
query?" to see if it explains what's wrong with the query and how to fix
it.