Access & VB - BUGS in database

Please see attached access database. In the scheduledSurgery form, you cannot scroll through the records. I do not think the updates on this form are working properly either. This code contains VB. Some of the fields on this form are populated from the patientInfo table. The firstname, lastname, surgeon, and patientID are pulled from the patientInfo table. The firstname/lastname field is working like this: When user opens up this form, and goes to the last record, he will have to press ADD to add a new record. The screen will clear except for the firstname/lastname fields. The lastname is a drop down menu. When lastname is selected from dropdown list, the firstname dropdown menus changes. If there is multiple patients with the same lastname, the user will have several choices in the firstname dropdown box. After user selects lastname/firstname combo, the patientID and the surgeon should be pulled from the patientInfo table. THIS IS NOT WORKING!! Also when user tries to scroll through the scheduledSurgery table, that does not seem to be working either. Please fix, THANKS! ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Access/VB