Updates to forms from different source

[Guest]

Hi yeserday I posted the message below and am very happy with the reply and
this is working well...

My question is re the last part "I need to be able to view the records with
all the updates (some kind of reporting) . This needs to be view only , non
editable "

reply "Just make a copy of your data-entry form and set its Allow Updates
property to False."

If I do this will any changes is the editable version be added to the non
editable one, If not is this possible?

Hope this makes sense





On Mon, 27 Jun 2005 11:30:02 -0700, "Dean Cowlishaw" <Dean

Im new to access and databases in general and would be gratefull for any
advice /help you could get me...

I need to create a database with records of about 50 individuals (various
feilds) , this I can do no problems.

What I need to do is have someway of selecting the record and then having a
free type text box where I can put an update/notes etc. on that record. This
needs to be date/time stamped and then added to the master record.

If each individual may have multiple notes, you need a second Table,
let's call it Notes. This could have the following fields:

NoteID << primary key, probably an Autonumber
PersonID << link to the Primary Key of the table of individuals
<< DON'T use the person's name as the key, names are not
<< unique!
Note << Memo field
NoteDate << Date/Time field, default value Now()

You could use a Form based on the people table, with a Subform based
on Notes to do your data entry.

I need to be able to view the records with all the updates (some kind of
reporting) . This needs to be view only , non editable

Just make a copy of your data-entry form and set its Allow Updates
property to False.



John W. Vinson[MVP]

 

[Joan Wild]

reply "Just make a copy of your data-entry form and set its Allow Updates
property to False."

If I do this will any changes is the editable version be added to the non
editable one, If not is this possible?

Yes the changes will appear in both forms. Remember that the data is stored
in tables, not forms. The form is just an interface to the underlying
table.

 

[Douglas J. Steele]

Since forms get their data from tables, and both forms will (presumably)
point to the same table, the answer to your question is Yes.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)