I finally seem to be getting somewhere with my database. I am concentrating on my MBR section. I input date and time data and shift data into the MBR table.
I am also taking data from other tables and filling in combo boxes with that data which then goes into the MBR table.
I have followed examples of code to allow the combo boxes to take their information based on what is chosen in the combo box above it.
All seems to be working great except if I fill the form in and then close it. If I fill it in and then go back to a record before, it appears to wipe out some of the data. When I then go back to the last one that I was updating, the data for the last two combo boxes (engineer and machine) are missing.
I suspect it is to do with the code in the event procedure, such as
Code:
Me.Combo206.Requery
Me.Combo206 = Empty
etc...
Can anyone see what i've done wrong?