About Subform "Dynaset"

[March]

Hello All,

I have questions about how to unlock the subform that I have the recordset
type as "Dynaset" in order to input data through user interface.
What I have done are
1) create subform by using wizard
- select table that I want to bulid the subform interface (I selected
all record at the beginning)
- This I can input all data I have into table via subform.
2) However,
- I do some modify the subform "record source" properties, add one more
table to link with the first table, and add one field from the second table
into the subform.
- At this point, I cannot input any data through the subforn.

I have no idea to correct it now. I try to make change through the subform
properties, it still doesn't work.

Please give me suggestion.


Thank you,

March

 

[Jeanette Cunningham]

Hi March,
after a major change to tables and table links, it is easier to start again
and build a new subform using the wizard.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[March]

Thank you.

Hi March,
after a major change to tables and table links, it is easier to start again
and build a new subform using the wizard.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia