AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Question I asked a question earlier about using unbounded controls and realize that there is probably a much more elegant solution to accomplish what I want to do in Access.
What I want is a form that does not use the recordset navigation, but instead uses ComboBoxes to navigate.
I am creating a simple note taking system that has only three fields Employee Name, Review Date and Notes. What I want to have happen is that a drop down box allows you to choose the Employee (the number of employees is fixed) a review date (quarterly) and notes.
If you choose an employee and a review date that has a record the notes should appear. If there are no notes the field should be blank and the user should be allowed to add notes that are then saved to the database.
How do I do this?
Right now I am doing this using unbound controls and a manual sql insert in code.
Thanks!
Answer First, I would add an autonumber primary key to your table. Second, I would set the table as the recordsource on a form. Third, I would use the combobox wizard to create a search combo, that allows you to search by name and date to bring up the matching records.
If there is no match for that persone and date, then just add a new record.
