Can you edit text boxes in a form that gets its data from a query?

[swarv]

Can you edit text boxes in a form that gets its data from a select query?

If not how can you?

cheers

 

[pbaldy]

Depends on the query:

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

 

[swarv]

I have looked at the above and dont think it is any of those reasons.
Any other ideas?
I'll try and think of a way round it.
cheers

 

[Atomic Shrimp]

Could you post the SQL for us to look at?

 

[pbaldy]

Check the locked property of the textboxes and the Allow Edits property of the form.

 

[pbaldy]

Oh, and the way to see if it's the form or the query is to see if you can edit data directly in the query.

 

[swarv]

I cant enter data in the query.
I have attached a copy of the query for you to have a look at.

Thanks

 

[pbaldy]

I suspect it's the fact that there is no join between the tables.

 

[swarv]

there is a one-to-many relationship between tbl_users.users_id and holiday.name

is this what you mean't?

 

[pbaldy]

Then you should have a join line between those fields in the query.

 

[swarv]

how do you mean?
will it mess up how the forms look at that query?

 

[jal]

Personally I wouldn't even imagine trying to edit a JOIN-based textbox. I'd find a way to code some alternative, for example let the user type the edit into a second textbox that's not query-bound and then I'd probably use the (second) textbox's AfterUpdate to update the database using CurrentDB.Execute SQL or something like that.