VBA code help

[noaccessguru]

Howdy,

I have a Form for each of my sites and I have a combo box for the user to select the site and based on the site selected need it to open the relevant form….How do I write this in VBA? (On Click event to a command button)

So I basically need it to say if ‘Combo Box = Victoria, open Frm_Vic, if it equals NSW then open Frm_NSW etc……(I have 8 sites all up) and I dont want to do a command button for each site.

I’m still not that great with code!

TIA!

[noaccessguru]

Figured it out

Thanks anyway! (wanted to delete the thread but can't?)

[ssanfu]

How about if I mark it solved??

[noaccessguru]

How about if I mark it solved??

I was looking for how to do this also but I couldn't figure it out? (maybe having a very blonde day) How do I do that myself for future reference please

[ssanfu]

In the green (on my computer) header just above the first post, there are options on the right :"Linkback | Thread Tools | Search Thread |Rate this thread".
Click on "Thread Tools"... should be the third option "Mark this thread solved".