Form will not display on start up

S

sirrahhc

I feel stupid for asking this but cannot figure out why my form won't
show...I have a few forms that search an SQL Db based on criteria
entered by users...the first form that comes up however should display
at start up asking what kind of search to perform...this was working
fine untill i renamed a form or 2, but not the one in question, this
form has remained the same...any ways, i'm just trying to display this
form on Workbook_Open()...when I open the workbook, i don't even get
an error, it just goes straight to debug...here's the simple line of
code:

Private Sub Workbook_Open()
frmBlow.Show
End Sub

this isn't even my program i'm referring to...my program starting
doing this crap so i created a new spreadsheet and inserted a dummy
form to see if i could get it to show at startup and it's doing the
same thing...any thoughts?? thanks in advance guys!!!
 
S

sirrahhc

I feel stupid for asking this but cannot figure out why my form won't
show...I have a few forms that search an SQL Db based on criteria
entered by users...the first form that comes up however should display
at start up asking what kind of search to perform...this was working
fine untill i renamed a form or 2, but not the one in question, this
form has remained the same...any ways, i'm just trying to display this
form on Workbook_Open()...when I open the workbook, i don't even get
an error, it just goes straight to debug...here's the simple line of
code:

Private Sub Workbook_Open()
frmBlow.Show
End Sub

this isn't even my program i'm referring to...my program starting
doing this crap so i created a new spreadsheet and inserted a dummy
form to see if i could get it to show at startup and it's doing the
same thing...any thoughts?? thanks in advance guys!!!

i resolved the issue by setting the ShowModal property to False...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top