Editing Forms

[perrydaniel]

Hi, I have a form which runs off a query, I would like to be able to edit details in the form. But when I try to overtype or add it is completly disabled! Though in properties "Allow Edits" is YES, any ideas?

 

[KenReay]

Hi

Maybe the query is not an updatable query?

Try running the query by itself, try typing into a column of the result set, can you update?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[perrydaniel]

KenReay,

No cannot update in the query? So can it be chnaged from the query?

Tanx

Perry

 

[KenReay]

Hi

You need to make it an updatable query

Not an exhaustive list but to begin:

Do you have:

any outer joins in it?

Group By Clause?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[perrydaniel]

No a simply query

 

[dRahme]

You might want to ensure you leave 'Data Entry' Unchecked in your form properties.

 

[KenReay]

Hi If the query is not updatable then it is not "Simple", it must have some characteristic which makes it none updatable

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[perrydaniel]

KenReay,

You are correct, my query is only selecting the Distinct transactions. AS I do not want to see any duplicate entries. Any ideas from here.

Many thanks for your time.

Perry

 

[PHV]

The DISTINCT predicate make a query not updatable, dot.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244