Saving data

[spiz via AccessMonster.com]

Hi~
My form iand subforms are all set up and ready for action, but will not save
any data i put into it.
(this is my 2nd time using Access 2003 and am learning as i'm going. i don't
understand relationships, but have managed to put one in so that everything
works. can also put script, but need very specific directions.)

 

[Rick Brandt]

Hi~
My form iand subforms are all set up and ready for action, but will
not save any data i put into it.
(this is my 2nd time using Access 2003 and am learning as i'm going.
i don't understand relationships, but have managed to put one in so
that everything works. can also put script, but need very specific
directions.)

Forms that are bound (have RecordSources), and which allow changes
(keystokes don't just "beep" at you) will either save those changes or raise
errors when they cannot. If you are not getting errors then the records
shoudl be getting saved.

Are you looking at the tables to verify the saves or in the form? Forms can
be set up to not show existing records or have filters applied that would
hide some of them.

 

[spiz via AccessMonster.com]

Thanks Rick,
I think the data is hidden b/c it IS showing up on the table, but not on the
form.
Which control will make it unhidden?

Hi~
My form iand subforms are all set up and ready for action, but will

[quoted text clipped - 3 lines]

that everything works. can also put script, but need very specific
directions.)

Forms that are bound (have RecordSources), and which allow changes
(keystokes don't just "beep" at you) will either save those changes or raise
errors when they cannot. If you are not getting errors then the records
shoudl be getting saved.

Are you looking at the tables to verify the saves or in the form? Forms can
be set up to not show existing records or have filters applied that would
hide some of them.

 

[Guest]

The "visible" property on the format tab.

Thanks Rick,
I think the data is hidden b/c it IS showing up on the table, but not on the
form.
Which control will make it unhidden?

Hi~
My form iand subforms are all set up and ready for action, but will

[quoted text clipped - 3 lines]

that everything works. can also put script, but need very specific
directions.)

Forms that are bound (have RecordSources), and which allow changes
(keystokes don't just "beep" at you) will either save those changes or raise
errors when they cannot. If you are not getting errors then the records
shoudl be getting saved.

Are you looking at the tables to verify the saves or in the form? Forms can
be set up to not show existing records or have filters applied that would
hide some of them.

 

[spiz via AccessMonster.com]

it is set to "yes" but still not able to see the data

The "visible" property on the format tab.

Thanks Rick,
I think the data is hidden b/c it IS showing up on the table, but not on the

[quoted text clipped - 15 lines]

 

[Rick Brandt]

Thanks Rick,
I think the data is hidden b/c it IS showing up on the table, but not
on the form.
Which control will make it unhidden?

If you have the DataEntry property set to Yes or Open the form from code
with the acFormAdd data mode argument then existing records are not shown.
DataEntry mode is strictly for adding new records.

Also look to see if the form's navigation button area indicates
"(filtered)".