By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

Entering data on a form that's record source is a query

P: 2
I cannot enter data on a form I'm using. I'm assuming this is because the record source is a query. Is there a way to allow me to enter data using a query? Thank you.
Oct 24 '08 #1
Share this Question
Share on Google+
5 Replies


DonRayner
Expert 100+
P: 489
I cannot enter data on a form I'm using. I'm assuming this is because the record source is a query. Is there a way to allow me to enter data using a query? Thank you.
You should be able to, here are some things that you could look at

1. Form opened in acview
2. Edit lock set in form properties
3. Poor query design
4. Key discrepancies in your underlying tables.

With a little debuging time you should be able to figgure it out. What have you done so far?
Oct 24 '08 #2

P: 2
You should be able to, here are some things that you could look at

1. Form opened in acview
2. Edit lock set in form properties
3. Poor query design
4. Key discrepancies in your underlying tables.

With a little debuging time you should be able to figgure it out. What have you done so far?
Thank you for your response. This is a simple query so the design should be ok. When you say acview, what do you mean by that? I tried changing the edit lock set to edited record and it still didn't work.
Oct 24 '08 #3

DonRayner
Expert 100+
P: 489
Thank you for your response. This is a simple query so the design should be ok. When you say acview, what do you mean by that? I tried changing the edit lock set to edited record and it still didn't work.
if the form is being opened like this

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "FormName", , , , acFormReadOnly
  2.  
Also it's not the edit lock, I guess I should have been more specific. On the properties setting for the form click on the data tab and check the Allow Edits, Allow Deletions, Allow Additions and Data Entry settings
Oct 24 '08 #4

NeoPa
Expert Mod 15k+
P: 31,186
If you run the query on its own, then you can see if the query is updatable by whether or not there is an empty line for adding a new record.

If there is no line for a new record, then the query is not updatable, and that means the data cannot be updated, whether from a form or otherwise.
Oct 25 '08 #5

missinglinq
Expert 2.5K+
P: 3,532
If your query is Read-Only, i.e if you cannot enter data when the query is opened independently of the form, follow this link to Allen Browne’s article explaining the reasons this happens.

http://allenbrowne.com/ser-61.html

Welcome to Bytes!

Linq ;0)>
Oct 25 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.