requery bottom form after closing pop up

[ck4794]

so i chose to operate with a main form for a person's "profile", and to view their respective documents via subform. nothing too complicated, and not really too relevant now that i think about it. but anyways, i chose to use the pop-up method of adding a new document (read attachment). i can't for the life of me seem to figure out how to make the profile form requery after i close the upload pop up. any suggestions?

also i work in macro builder, and query design windows. i'm not fluent at all in code, though i realize it's what actually makes the db work.

[Dal Jeanis]

Two ideas -

First, you can make the popup modal, and in the button code/macro where the popup is created, make the next line the Requery on the form.

Second, you can pass the name of the calling form to the popup form, and requery the parent in the popup Form's Close event.

For me to be more specific, you'd have to post exactly how you are causing the popup form to appear.

[ck4794]

i'm going to try and explain it intelligently, forgive me if i fail...
for the record source, i'll give background info. the documents are stored in one table, and the profiles are in another, linked by the profile.id. the pop up's record source is the image table. on open event is go to new, and set value of a non visible control to profile.id (which is a non visible control on the profile form which is still open). select your file via attachment manager (which i would love to find a way to get rid of and just have a "browse" button or something, but that's another question for later), select the type of document it is (a combo box which looks up from a 3rd independent table linked to the document table), and click "upload" button, which on click is save record, close form.

this is where i end up back at my profile form which now needs to requery to show the document i just added.

sorry if it seems kind of jumbled.

[ck4794]

i looked up what modal means. that idea seems to have done the trick. i may have to try it else where.

[Dal Jeanis]

Good job. Please mark thread solved. Top of page, under "Thread Tools".