Retriving a recordset

[scharee]

i have a field in my form, what i need to do is that on After Update event i
run a procedure where i can show a few related fields from an other table
shown in the same form.
i did this by updating the main table fields then displaying them. but i
need to enter the first fields data and get the related info using sql from
an other table and display them in the same form then lastly on save and exit
i need to save the query data in the parent table!!

 

[Mr. B]

scharee,

This sounds like a place where you need to use a sub form. Look in the
Access Help file for sub forms or just Google for information on the subject.

Sub Forms can display records related to the current record in the main form.

-----
HTH
Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm

 

[scharee]

might not be exactly what i want but should serve the purpose for the moment.
thanks a lot forur support