>This is the sp call that I've put in the rowsource property. My question is -is it an option to put this in the REQUERY instead? I don't think I want to, since it seems to be more trouble.
>=SQLEXEC(gnid, "exec sp_agent_lookup '"+p.co+"', '"+p.dbacomp+"', '"+p.poltype+"'", "agentlookup")
No, probably not. If it works the way it is, you just leave REQUERY empty to perform it's default action.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison