Updateable Query Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,

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.

John H W said:
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

cvegas said:
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];
Click to expand...
Click to expand...
 
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
 
Back
Top