Visual Basic

[Darth21]

I created a Vehicle Maintenance Database for our company vehicle. There are four shift in a day for example: There is Early Morning shift, Day shift, Mid Shift and Swing Shift. Each employee is to check out the vehicle and inspect it for dents and scratches and make a notification on the vehicle checkout sheet. I then input the changes in the Vehicle Checkout Log in Microsoft Access. I created a tab for all four shift within the form, but i am getting error messages.



So i want to use Visual Basic using a combo box to show when i select Day Shift the form appear, and when nothing is selected it doesn't show up. but this requires visual basic code which i am not familiar with. Do any one know how to do this?

Thanks for any input would help.

Darth21.

[June7]

What are the error messages?

At least one page of a tab control must always be visible.

Really need to know more about the db structure. If you want to provide for analysis, follow instructions at bottom of my post.

[Darth21]

The error message that i get says: "The changes you requested to the table were not successful because they would create duplicate vales in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again."

When I hit the undo button and move to a new record and go back it lets me enter information into the tab and everything is ok, but when i try to do a new record and enter information into the tab it gives that error message again.

[June7]

Error message seems clear enough. Whatever you are doing for data entry is causing duplication of data that can't be duplicated.

Like I said, need to know more about db structure.

[ranman256]

Your table must have keys that dont allow mutiple records on something. The form is adding these.