Saving data

  • Thread starter spiz via AccessMonster.com
  • Start date
S

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.)
 
R

Rick Brandt

spiz said:
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.
 
S

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?

Rick said:
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.
 
S

scubadiver

The "visible" property on the format tab.




spiz via AccessMonster.com said:
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?

Rick said:
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.
 
S

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]
 
Top