Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2007

Tip: Looking for answers? Try searching our database.

data entry on form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Beth - 08 Mar 2007 20:04 GMT
Hello - I'm new to Forms.  I created a query pulling data from multiple
tables/queries and including some calculated fields.  I want to show the
results of the query in a form AND allow a user to update two fields in
tables that were used in the source query.  When I create the form from the
query, it doesn't allow me to update the field.  I've read the help and
enabled input on the field, but it's not working.  I tried to add a subform
where I linked the query to the source table where the data is stored, but I
can't get that field to show up on the form.  I know this can be done, just
not how.....
Thank you in advance for your help!
Allen Browne - 09 Mar 2007 02:14 GMT
Beth, open the query.
Can you update the fields you want in the query?

- No: I can't update the fields in the query.
==============================
Then you won't be able to update them in the form either.
For a check list, see:
   Why is my query read-only?
at:
   http://allenbrowne.com/ser-61.html

- Yes: I can update the fields in the query.
==============================
In this case, it's time to examine the properties of the form. On the Data
tab of the Properties box (looking at the properties of the form, not a text
box), you need:
   Allow Edits        yes
   Data Entry         no
   Recordset Type  Dynaset
For the controls, the Locked property should be No, and the Enabled property
Yes.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello - I'm new to Forms.  I created a query pulling data from multiple
> tables/queries and including some calculated fields.  I want to show the
[quoted text clipped - 10 lines]
> not how.....
> Thank you in advance for your help!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.