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

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

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

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

Thanks,
John

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

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).]

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 http://www.access-programmers.co.uk/ubb/smile.gif

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).]

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).]