Opening/Closing Forms using Code

[Wicklund]

I have some code that is opening a form, getting date, closing the form, opening another form, pasting the data, and then closing that form as well.

This step is repeated about 12 times, and watching the screen flash can give a person a head ache.

Can the code be set up, so when opening & closing forms, they don't flash on the screen?

Thank you,

Steve

 

[Fornatian]

Use the Application.Echo method, look it up in VBA.

 

[Wicklund]

Now I am really confused.

I used the "docmd.echo false" at the beginning of my code to prevent the screen from updating while the code is running. However, when the window is maximized, the screen still updates (i.e. the "docmd.echo false" is ignored).

Any Ideas why?????

 

[Fornatian]

Take Pat's advice and use queries, otherwise if you wish to continue down your existing route then you could open the forms in hidden mode, reference the value then close without the flickering

 

[Wicklund]

Accessing Queries

Pat,

Thank you for letting me know about the DLookup function in your last posting. I am a self taught Access programmer, and have not come across this on yet.

Also, I understand that data is stored in tables (not forms). I was just using the form to access data in the table, based on criteria (see below). I am then checking the data, record-by-record, and copying it to different tables so it can be charted based on the remaining information.

stLinkCriteria = "([Mfg Completion Date] is null " _
& "or [Mfg Completion Date] >=" & FiscalYearStart ")" _
& "and [Customer] = 'Turbines'"

Do you have any advice as to how to open a querie, based on this criteria? I would like to be able to set the criteria in the code, and not 'hard code' it in the querie itself.

Thank you for your help,

 

[Wicklund]

Thanks againg Pat....