CHECKING FOR FORM BEING OPENED

[sbornstein1]

I have a form that based on coming from a specific form I want to make the form editable and change the Me.Recordsource instead of maing a new form. Any idea how I can check first if the form is opened, because it will give me an error I think if the form is not opened and I do an IF statement. Thanks

 

[AccessUser]

If CurrentProject.AllForms("YourFormName").IsLoaded Then

 

[Fornatian]

Open the Northwind database(Access's sample) and copy the IsLoaded function from the module. You will then be able to say:

If IsLoaded("MyFormName") then
'do this
Else
'do that
Endif


If you can't find it please reply and I'm sure someone will post it - I'm not on an access machine at the mo so can;t do it myself.

Ian

 

[jrizzo]

I was just searching through posts and saw this question and was curious if this works for Reports also?

Thanks,
John

 

[Pat Hartman]

jrizzo,
Why not try it and see. Worst case is you'll learn something.

 

[jrizzo]

Your mother must be proud of you! Can't a guy just ask a question?

[This message has been edited by jrizzo (edited 08-24-2001).]

 

[KDg]

nice try, but Pat's a little more mature than you and me. Flaming her for a reply a month ago is unlikely to get you a response. But i like your style anyhow

 

[Rich]

Don't you realise who you are talking to, don't you realise the status he's achieved as an employee, don't you stand in awe of Johnny? Na me neither!

[This message has been edited by Rich (edited 08-24-2001).]

 

[KDg]

Hehe, unfortunately i think you may have used sarcasm in your post, probably won't get it. How'r pompey doing this season then? Seagulls 6th from top of the 3rd - that's success to us y'know.

Anyone else getting hit by a pile of firewall messages while viewing this forum? - seems to trace back to Kornet.net via teleglobe.net, but anything's spamable i guess.

Drew

[This message has been edited by KDg (edited 08-25-2001).]