7952 You made an illegal function call.

[syedshaffee]

Hey people,
Need your help again i'm getting "7952 You made an illegal function call."

i m getting a message "This RecordSet is not updatable"
i don't want that message to be displayed on the status bar and i have used SysCmd method with acSysCmdSetStat us as its parameter but it doesn't work

Doevents
SysCmd(acSysCmdClearStatus)

[twinnyfo]

syedshaffee,

Is your question regarding the error or regarding the message displayed?

If it is concerning the actual error, that type of error typically occurs when you are trying to update a table from a query, but the design of the query prevents the DB from performing such an update, usually, because the specific field is ambiguous or aggregated.

If you are concerned about the warning message, one way to turn these messagees off is to use this code:

    DoCmd.SetWarning False
    'Insert your code here
    DoCmd.SetWarnings True

But, either way, you should have effective Error Handling code built into all of your VBA, so that you will be able to know when your code malfunctions and where and why, without your DB locking up or crashing.

Let me know if this helps.

[syedshaffee]

Thanks for the reply And yes the query design view of the query prevents the DB from performing such an update

Thanks a lot

[syedshaffee]

I Didn't Knew thanx for the Explanation twinnyfo

[twinnyfo]

My pleasure. Glad I could help!