Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Updating dynaset while keeping from open


Message #1 by lennard@n... on Thu, 10 May 2001 08:54:08
I have a from based on a query with three tables. One field in the form is 

an autolookup, that does not allow for entry other than from the combobox 

lookup. The user then opens the add new operator form, enters the new 

information.



Question, can I update the query that is running the main form without 

closing it??



Stephen Ward

Message #2 by "John Ruff" <papparuff@c...> on Thu, 10 May 2001 02:29:45 -0700
After adding new data on the New Operator form, requery the main form and

the autolookup combobox on the main form.  These two operations could be

done in the New Operator form's Close Event.



John Ruff - The Eternal Optimist :)

 -----Original Message-----

From: 	lennard@n... [mailto:lennard@n...]

Sent:	Thursday, May 10, 2001 8:54 AM

To:	Access

Subject:	[access] Updating dynaset while keeping from open



I have a from based on a query with three tables. One field in the form is

an autolookup, that does not allow for entry other than from the combobox

lookup. The user then opens the add new operator form, enters the new

information.



Question, can I update the query that is running the main form without

closing it??



Stephen Ward










Message #3 by "lennard" <lennard@n...> on Fri, 11 May 2001 15:47:26 +1000

John,



Thanks for the response, I should have thought of it myself.



Stephen Ward




  Return to Index