I have a userform with a calendar control (date), a text box (notes), and a command button (submit). The user selects a date, enters some notes and then clicks the submit button, the data is then saved to the next empty row in the worksheet.
I only want the user to enter one set of notes for any given date (to avoid duplicates) how can I get the notes to update based on the calendar control. For example, the user selects the 01/01/10 from the calendar control, there are already notes saved for this date previously, the notes text box then displays these notes, instead of simply adding a new ‘record’.
I’m not sure on the best way to approach this, I have considered using advanced filter, vlookup, neither seem very efficient - any pointers on how i should approach this?


LinkBack URL
About LinkBacks
Reply With Quote



In my experience businesses that have invested in MS Office often go for the Professional version, which *does* include Access, but on the other hand I once had to write an entire data entry and management tool in Word, because the client's IT department wouldn't even give them Excel... 
