Hi,
I have attached the database that i am currently working on. It will be to track my companies hires.
I am having a problem with the subform that will be used to enter all the specific items - it is on page 2 of the tabbed box.
I have included 2 main forms and 2 sub forms to show what happens with each of them - frmHire and frmHire2 are the main forms and frmHireDetailsSub and frmHireDetailsSub2 are the subforms.
Ideally i would like to use the first set of forms because the subform is using continuous forms where as the second one is using a datasheet view. The problem with this is that because it is using continuous forms, any changes i make to the combo boxes are reflected right down the grid - so if you go in and add say a laptop from the first drop down - the rest of the grid above clears. If you do the same thing in the Datasheet form - it keeps the old information (which is the way i want it to work).
I really would prefer to use the continuous forms method as it gives me more control over the look (alternating row colours which are not yet implemented, delete button etc) but am stuck at the moment.
Can anyone provide any help with this or will i be stuck on Datasheet view?
file can be found at
www.ifstar.pwp.blueyonder.co.uk/work/test.zip (117k)
I have attached the database that i am currently working on. It will be to track my companies hires.
I am having a problem with the subform that will be used to enter all the specific items - it is on page 2 of the tabbed box.
I have included 2 main forms and 2 sub forms to show what happens with each of them - frmHire and frmHire2 are the main forms and frmHireDetailsSub and frmHireDetailsSub2 are the subforms.
Ideally i would like to use the first set of forms because the subform is using continuous forms where as the second one is using a datasheet view. The problem with this is that because it is using continuous forms, any changes i make to the combo boxes are reflected right down the grid - so if you go in and add say a laptop from the first drop down - the rest of the grid above clears. If you do the same thing in the Datasheet form - it keeps the old information (which is the way i want it to work).
I really would prefer to use the continuous forms method as it gives me more control over the look (alternating row colours which are not yet implemented, delete button etc) but am stuck at the moment.
Can anyone provide any help with this or will i be stuck on Datasheet view?
file can be found at
www.ifstar.pwp.blueyonder.co.uk/work/test.zip (117k)
Last edited:
