Updateable Query Problem

[cvegas]

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];

 

[cvegas]

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"
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
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];

 

[John H W]

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