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

[jromito]

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.

[DonRayner]

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?

[jromito]

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.

[DonRayner]

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

DoCmd.OpenForm "FormName", , , , acFormReadOnly

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

[NeoPa]

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.

[missinglinq]

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)>