Hopefully this will make sence. Here is my problem, I have a form that
takes some data from a database in the when "load" procedure is run. The
problem is that the database is not available when coding the problem at
design time. The load procedure seems to run even at design time. I
remember from earlier versions of VB there was a command I could enter at
the beginning of the procedure to exit out if it was desgin mode.. But for
the life of me I can not recall what it was nor can I figure it out in the
current version... Anyone have any ideas?

Thanks,
David

I think I came up with a better way to ask the question, is there some way
to determine Runtime -vs- Design time?

Thanks again



"D Miller" <(E-Mail Removed)> wrote in message
news:zhqec.5864$(E-Mail Removed)...
> Hopefully this will make sence. Here is my problem, I have a form that
> takes some data from a database in the when "load" procedure is run. The
> problem is that the database is not available when coding the problem at
> design time. The load procedure seems to run even at design time. I
> remember from earlier versions of VB there was a command I could enter at
> the beginning of the procedure to exit out if it was desgin mode.. But
for
> the life of me I can not recall what it was nor can I figure it out in the
> current version... Anyone have any ideas?
>
> Thanks,
> David
>
>

"D Miller" <(E-Mail Removed)> schrieb
> Hopefully this will make sence. Here is my problem, I have a form
> that takes some data from a database in the when "load" procedure is
> run. The problem is that the database is not available when coding
> the problem at design time. The load procedure seems to run even at
> design time. I remember from earlier versions of VB there was a
> command I could enter at the beginning of the procedure to exit out
> if it was desgin mode.. But for the life of me I can not recall what
> it was nor can I figure it out in the current version... Anyone have
> any ideas?

I think it only runs if you design a form derived from the Form containing
the code.


If not me.designmode then
'database stuff
end if


--
Armin

How to quote and why:
http://www.plig.net/nnq/nquote.html
http://www.netmeister.org/news/learn2quote.html