new data won't save on form

  • Thread starter Thread starter MitziS
  • Start date Start date
M

MitziS

I have a Form only, which is linked to table to retrieve the static info I
want displayed. It has 4 other "allow " columns on this form. I have the
properties of the form set to "no data entry". The properties on the 4 other
areas are allow editing, etc. The static columns are set to "lock". When I
go to key in the new info in the columns which allow it, the same info
appears on ALL records on the form , and NONE saves. I do not have this info
set to "record" to a table , or anything of the sort. This is a data
entry/look up form only. I do not need the info saved anywhere else.
I have another form created like this also, though it does have a underlying
table it saves to. I use it for editing info. And it works wonderfully.
I have had forms in the past which weren't link to anything, and could use as
data entry only, and never had a problem.
What have I done?
 
It is in single form mode. I am guessing that the problem lies in the
individual columns that I have "allow" on. I see nothing that would cause it
to be this way. I would think the problem with data entry on one record
copying to all the records would also be the reason it won't auto save. I
always thought that access saved any entries when closed or focus was moved
away from the record

Wayne-I-M said:
Hi Mitzis

Open the form in design view and change the format to Single form
I have a Form only, which is linked to table to retrieve the static info I
want displayed. It has 4 other "allow " columns on this form. I have the
Click to expand...
[quoted text clipped - 9 lines]
data entry only, and never had a problem.
What have I done?
Click to expand...
Click to expand...
 
Back
Top