Open form for Edit

[djpearce]

Hi. I created a form to be used for editing records. It displays ALL records in a "Files" table that match the BoxNo entered on a previous form. The record source is a query which has a relationship between the tblBoxes (one) and tblFiles (many). The records are showing in the form correctly but it will not allow me to edit.

I have set the allow edit, addition, deletion properties of the form to YES, and data entry to NO. Fields are not locked, and they have active tab stops. I also tried using VBA and set the datamode to edit.

Help please!?!
DJP

 

[andrew93]

Can you edit any of the fields in the underlying query?
Andrew

 

[Gilrucht]

Try setting data entry to yes. Editing can include adding data in some situations. For example, suppose a field was previously left blank because the data was not yet available. Now you want to "edit" the record by adding the data to blank field.

 

[Gilrucht]

Sorry, Pat.
I should keep my mouth shut. I'm too inexperienced to be trying to answer questions. I should know better. I ask too many questions myself to be trying to answer others.

 

[Gilrucht]

Thanks for the encouragement. I will.