Weird one, client cannot change a combo box price when i can

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Weird one, client cannot change a combo box price when i can

Post by Pat »

What can I look for in this, I have access 2007 and 2010, but generally use 2010.
I have tested this on 2007 and 2010 on my computer.

User avatar
HansV
Administrator
Posts: 78233
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Weird one, client cannot change a combo box price when i

Post by HansV »

Can the user edit other values on the same form?
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Weird one, client cannot change a combo box price when i

Post by Pat »

It happens in a subform, he cannot I can, same FE. He says it shows "This record set is not updatable" what can do this to his, yet mine is ok?

User avatar
HansV
Administrator
Posts: 78233
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Weird one, client cannot change a combo box price when i

Post by HansV »

You'll have to investigate the record source of the subform. I'm afraid I can't tell what causes the problem from a distance.
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Weird one, client cannot change a combo box price when i

Post by Pat »

Thank you for looking at this perplexing problem.
I would understand that if it happened on my computer as well as his. But this only happens on his computer and not mine.
The SQL is:
SELECT [Order Details CurrentPrice].ItemNo, [Order Details CurrentPrice].ClientPartNo, [Order Details CurrentPrice].CategoryID AS Category, [Order Details CurrentPrice].ProductDescription, UOM.UOM, [Order Details CurrentPrice].SumOfQuantity, [Order Details CurrentPrice].CurrentPrice, [Order Details CurrentPrice].OrderID, ([SumofQuantity]*[CurrentPrice])*12/[forms]![Add an Order and Details]![ExpenditurePeriod] AS [Extended Annual Total], [Order Details CurrentPrice].uomid FROM [Order Details CurrentPrice] LEFT JOIN UOM ON [Order Details CurrentPrice].uomID = UOM.uomID;Of which the following fields not Enabled:
ClientPartNo
ProductDescription
SumOfQuantity

The only fields shown on the form are:
[Order Details CurrentPrice].ItemNo, [Order Details CurrentPrice].ClientPartNo, [Order Details CurrentPrice].CategoryID AS Category, [Order Details CurrentPrice].ProductDescription, UOM.UOM, [Order Details CurrentPrice].SumOfQuantity, [Order Details CurrentPrice].CurrentPrice

User avatar
HansV
Administrator
Posts: 78233
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Weird one, client cannot change a combo box price when i

Post by HansV »

Is 'Order Details CurrentPrice' a table or a query?
Is uomID the primary key in either 'Order Details CurrentPrice' or UOM?
Best wishes,
Hans

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Weird one, client cannot change a combo box price when i

Post by Pat »

'Order Details CurrentPrice' is a table

uomID is the primary key in UOM

User avatar
HansV
Administrator
Posts: 78233
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Weird one, client cannot change a combo box price when i

Post by HansV »

Hmm... Do you have code that toggles the AllowEdits property of the subform?
Best wishes,
Hans

User avatar
burrina
4StarLounger
Posts: 550
Joined: 30 Jul 2014, 23:58

Re: Weird one, client cannot change a combo box price when i

Post by burrina »

Replace his FE with yours. I would suspect corruption.

Pat
5StarLounger
Posts: 1148
Joined: 08 Feb 2010, 21:27

Re: Weird one, client cannot change a combo box price when i

Post by Pat »

no code changes AllowEdits.

I will ask for his FE and try that.