Updateable Query Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cvegas - 31 May 2005 23:39 GMT

If I run this query alone I can click on the PaidFromQB field and it will
update. When I create a form, based on this query, I can not click on the
field and update it?

Any ideas would be appreciated.

SELECT [Accounts Payable].V_CODE, [Accounts Payable].[DATE RECIEVED],
[Accounts Payable].[VENDOR INVOICE #], [Accounts Payable].[AMOUNT BILLED],
[Accounts Payable].[AMOUNT PAID], [Accounts Payable].PAID, [Accounts
Payable].[CHECK #], [Accounts Payable].[CHECKING ACCOUNT], [Accounts
Payable].AccountingCompanyID, [Accounts Payable].PaidFromQB, [Accounts
Payable].ProcessedDate, [Accounts Payable].[DATE PAID]
FROM [Accounts Payable]
WHERE ((([Accounts Payable].PAID)=0))
ORDER BY [Accounts Payable].V_CODE, [Accounts Payable].[DATE RECIEVED];

Reply to this Message

John H W - 01 Jun 2005 00:18 GMT

You could put in an 'On_Click' event on the form that would rerun the query,
but from a user's point of view, it would be better to put in an "Update"
command button. In the Categories: area, select "Form Operations" and in the
Actions: area select "Refresh Form Data".

John H W

> If I run this query alone I can click on the PaidFromQB field and it will
> update. When I create a form, based on this query, I can not click on the
[quoted text clipped - 11 lines]
> WHERE ((([Accounts Payable].PAID)=0))
> ORDER BY [Accounts Payable].V_CODE, [Accounts Payable].[DATE RECIEVED];

Reply to this Message

cvegas - 01 Jun 2005 00:15 GMT

John,

Thanks for your reply. I created another form from scratch and it appears
to be working ok. I think thiat this might have been becuase the other form
was looking to an obdc database to pull in company names.

Again thanks for the input.

> You could put in an 'On_Click' event on the form that would rerun the query,
> but from a user's point of view, it would be better to put in an "Update"
[quoted text clipped - 18 lines]
> > WHERE ((([Accounts Payable].PAID)=0))
> > ORDER BY [Accounts Payable].V_CODE, [Accounts Payable].[DATE RECIEVED];

Reply to this Message