Has it always behaved that way at boot, or is it only since you installed Windows 7?
Is the CD drive on a PATA connection and the HDD on a SATA connection? If so, does disconnecting the CD drive enable the PC to boot from the HDD? In which case, check to see if a BIOS update is available for your motherboard.