Unable to modify data in the form (1 Viewer)

I

iworkonline

Registered User.

Local time

Yesterday, 19:06

Joined

May 25, 2010

Messages

44

• Jun 16, 2010

• #1

I have created a form in design view, the Record Source is based on a query and Data Entry property is set to Yes.

I am not able to edit the fields. I am opening the form from the Forms screen. I am using Access 2003 in Citrix enviornment.

The query is in parameterized form, the parameters are getting values from the VBA functions.

If you need more information, plz let me know.Thanks.

 

boblarson

Smeghead

Local time

Yesterday, 19:06

Joined

Jan 12, 2001

Messages

32,059

• Jun 16, 2010

• #2

What is the underlying SQL of the query?

See here for why a query can be read-only.

 

I

iworkonline

Registered User.

Local time

Yesterday, 19:06

Joined

May 25, 2010

Messages

44

• Jun 16, 2010

• #3

My form is uneditable because the query is using Max().

Thanks for the tip, Bob.

 

Last edited: Jun 16, 2010

boblarson

Smeghead

Local time

Yesterday, 19:06

Joined

Jan 12, 2001

Messages

32,059

• Jun 16, 2010

• #4

Glad we could help.