A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Read Only Forms



 
 
Thread Tools Display Modes
  #1  
Old January 19th, 2010, 02:17 PM posted to microsoft.public.access.forms
Laura
external usenet poster
 
Posts: 458
Default Read Only Forms

I have created a form containing subforms. However i can not add new records
using this form as access says it is read only. How do i remove the read only?
  #2  
Old January 19th, 2010, 02:22 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Read Only Forms

Make sure that the underlying query allows data adding/editing. If the query
is editable, then look on the Data tab of the form's property sheet, and
changes anything that asks "Allow" to yes.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Laura" wrote in message
...
I have created a form containing subforms. However i can not add new
records
using this form as access says it is read only. How do i remove the read
only?



  #3  
Old January 19th, 2010, 02:23 PM posted to microsoft.public.access.forms
Golfinray
external usenet poster
 
Posts: 1,597
Default Read Only Forms

If the source of the form is not editable, the form won't be either. The
table or query that runs the form should NOT have the arrow and asterisk at
the bottom greyed out. Also make sure the link master and child fields are
set properly and that allowedits is set to YES.
--
Milton Purdy
ACCESS
State of Arkansas


"Laura" wrote:

I have created a form containing subforms. However i can not add new records
using this form as access says it is read only. How do i remove the read only?

  #4  
Old January 19th, 2010, 02:37 PM posted to microsoft.public.access.forms
Keith Wilby
external usenet poster
 
Posts: 812
Default Read Only Forms

"Laura" wrote in message
...
I have created a form containing subforms. However i can not add new
records
using this form as access says it is read only. How do i remove the read
only?


More info required. For example, how are the forms related to each-other?
The more info you provide, the better chance of getting a useful answer.

Keith.
www.keithwilby.co.uk

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:28 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.