Open a Form in a subform automatically

[Tracy]

Dirk, Remember me? I ran into a little problem with the edit form named
f_PrimaryEntry. For some reason it won't let me edit any of the data. I
really don't want it set up to edit all data but I can't edit any of it. The
subform is driven from a query but the query is only composed of tables.
I've looked at the obvious. It's set up for to allow additions, deletions,
record lock no, can grow yes, can shrink yes, data entry yes but nothing is
letting me edit. Is there a code that I can incorporate to allow edits?

Thanks.

Tracy

 

[Graham Mandeno]

Hi Tracy

Do you mean you want to edit records you have previously created and saved?
If so, then DataEntry=Yes is the problem. That means that the form opens in
a mode to only add new records, so existing records are not displayed.

If the problem is that you can't even edit the new records you add, then
first check your RecordSource query to see if it is updateable. Open the
query directly and try to edit the data.


BTW, CanGrow and CanShrink have nothing to do with it. They only refer to
the height of controls when you print a report (or form).

 

[Tracy]

Graham, Thanks for responding. What could be the problem if it still won't
let me edit and I set it to data entry no?

Thanks.

Hi Tracy

Do you mean you want to edit records you have previously created and saved?
If so, then DataEntry=Yes is the problem. That means that the form opens in
a mode to only add new records, so existing records are not displayed.

If the problem is that you can't even edit the new records you add, then
first check your RecordSource query to see if it is updateable. Open the
query directly and try to edit the data.


BTW, CanGrow and CanShrink have nothing to do with it. They only refer to
the height of controls when you print a report (or form).
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Dirk, Remember me? I ran into a little problem with the edit form named
f_PrimaryEntry. For some reason it won't let me edit any of the data. I
really don't want it set up to edit all data but I can't edit any of it.
The
subform is driven from a query but the query is only composed of tables.
I've looked at the obvious. It's set up for to allow additions,
deletions,
record lock no, can grow yes, can shrink yes, data entry yes but nothing
is
letting me edit. Is there a code that I can incorporate to allow edits?

Thanks.

Tracy

 

[Graham Mandeno]

Hi Tracy

First check that AllowEdits is Yes.

If that's OK, open the query directly and see if you can edit the cells in
datasheet view. If not, you have a non-updateable query. This happens for
a number of reasons, the most common being that you have a DISTINCT or GROUP
BY clause, or you have an outer join where both the joined fields are not
present in the query.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Graham, Thanks for responding. What could be the problem if it still
won't
let me edit and I set it to data entry no?

Thanks.

Hi Tracy

Do you mean you want to edit records you have previously created and
saved?
If so, then DataEntry=Yes is the problem. That means that the form opens
in
a mode to only add new records, so existing records are not displayed.

If the problem is that you can't even edit the new records you add, then
first check your RecordSource query to see if it is updateable. Open the
query directly and try to edit the data.


BTW, CanGrow and CanShrink have nothing to do with it. They only refer
to
the height of controls when you print a report (or form).
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Dirk, Remember me? I ran into a little problem with the edit form
named
f_PrimaryEntry. For some reason it won't let me edit any of the data.
I
really don't want it set up to edit all data but I can't edit any of
it.
The
subform is driven from a query but the query is only composed of
tables.
I've looked at the obvious. It's set up for to allow additions,
deletions,
record lock no, can grow yes, can shrink yes, data entry yes but
nothing
is
letting me edit. Is there a code that I can incorporate to allow
edits?

Thanks.

Tracy

 

[Tracy]

Yes, it's not updateable. It's a crosstab. Thanks.

Hi Tracy

First check that AllowEdits is Yes.

If that's OK, open the query directly and see if you can edit the cells in
datasheet view. If not, you have a non-updateable query. This happens for
a number of reasons, the most common being that you have a DISTINCT or GROUP
BY clause, or you have an outer join where both the joined fields are not
present in the query.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Graham, Thanks for responding. What could be the problem if it still
won't
let me edit and I set it to data entry no?

Thanks.

Hi Tracy

Do you mean you want to edit records you have previously created and
saved?
If so, then DataEntry=Yes is the problem. That means that the form opens
in
a mode to only add new records, so existing records are not displayed.

If the problem is that you can't even edit the new records you add, then
first check your RecordSource query to see if it is updateable. Open the
query directly and try to edit the data.


BTW, CanGrow and CanShrink have nothing to do with it. They only refer
to
the height of controls when you print a report (or form).
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Dirk, Remember me? I ran into a little problem with the edit form
named
f_PrimaryEntry. For some reason it won't let me edit any of the data.
I
really don't want it set up to edit all data but I can't edit any of
it.
The
subform is driven from a query but the query is only composed of
tables.
I've looked at the obvious. It's set up for to allow additions,
deletions,
record lock no, can grow yes, can shrink yes, data entry yes but
nothing
is
letting me edit. Is there a code that I can incorporate to allow
edits?

Thanks.

Tracy