Recent content by limawhiskey

Thanks arnelgp, I have just noticed that if I put the DoCmd.GoToRecord , , acNewRec in the On Current event, it seems to load with a blank form. I am conscious that I am new to this and as it wasn't suggested don't know if this is a good idea. Is there any negative to putting it in the on...

Hi arnelgp, The idea is there is one record for the individual but they may have many test records over the years as they come back time and time again. The employee record will rarely change it will just have a record in each individual test table to show how many they have had etc.

Hi Arnelgp, Thanks for the feedback when you open the Mickey record it shows the last record rather than opening a blank record.

Morning, I have managed to strip the database back. The username is test and password is 1234. Thank you :)

Hi Smig, On the employee table the primary Key is their employee number and on each of the sub-forms the primary key is an auto-number. There relationship is based on the employee ID on each table.

Hi smig, Thanks for the quick response. I don't get any errors it just runs but when I open the tab with the sub-form on it is already populated with the last entry for the selected individual. If there is no entry for the individual then the form is blank. I don't believe I have set/touched...

Morning Linq, I have just tried this and still getting the same result, I tested the code with a message box so I know its firing the load command.

Thanks for the quick response, sadly I cannot, I have tried to strip the system back and take all the data out to share but there are more problems with this due to how its setup with login forms and various checks including search forms etc. I have provided screenshots I know it's not as helpful.

Hi Guys, I am extremely new to Access and this is my first project using it, i'm normally an Excel kinda guy but like the flexibility and easier user elements of access. I have a form which is linked to 5 different tables when the user selects a colleague it opens up their record. They will...