I have an Access 2003 database which has a tblContact and a tblVehicle. On my form "Contacts" if someone tries to put in a vehicle NOT IN LIST, I have an event that tells them the item in not in the list, do they want to add it, and if they say YES, it opens up the vehicle data entry form "vehicles" (see code below). They enter the new vehicle information, save it and it pops them back in the Contacts form populating the field. All this works great.
My question is this...when the new vehilce is being entered on the vehicle entry form, I wanted to put previous and next buttons so the user could scroll through all the entries in the tblVehicle as well as correct data entry errors from prior entries. This keeps the users out of the database. Problem is, I cannot scroll to anything from this form "vehicles" Is it possible? If so, how? I don't want to have to build another form just to allow maintenace on tblVehicles.
Dim MsgStr As String
MsgStr = "'" & NewData & "' is not setup as a Vehicle. Do you want to add it?"
If vbYes = MsgBox(MsgStr, vbYesNo + vbQuestion, "New Vehicle?") Then
DoCmd.OpenForm "vehicles", acNormal, , , acFormAdd, acDialog
Response = acDataErrAdded
Response = acDataErrDisplay