I have attached the workbook. Thanks again RoyUK
Found a solution to the issue,
this option seems to do the trick, i was hoping to have it pull from a list but this will do also., now i just need to see if i can have other boxes(combo/text) gray out based on value of another one. that way it prevents having to enter information that is not going to be needed. One question i did have, is if there is a way to have a counter option to enter a number based on the date, for example, if it is the 1st record for the date, then it would enter a 1, then second entry will be a 2, and so on.
Any help would be appreciated.
Bookmarks