I have subform as datasheet named hoursentry that is based on table name project hours and it opens in add mode, on main form there is a combox to select contractor and it puts contractor name in subform datasheet field contractor with after update event. However, I need to change the combo box because contractors could enter hours incorrectly. Hence, I want to have contractor name preselected on open so no possibility of errors.
Attachment 15840
Attachment 15841
I have macro on load event to select contractor combo box.The predicament I am in is I want to limit form to specific contractor selectedfrom query and entered in contractor field in subform form. This form is basedon query for contractor and table project hours opened in add mode.
Thanks for your assistance I do not know if pictures are viewable first time uploading screen shot