Recent content by Mark Nash

This is how it currently looks:

Thanks Gasman, I will have to strip the data already on the DB before I can post it on here. However, from the relationship that already exists between the Contacts (ID) autonumber field on the Contacts table to the Assigned To Text field in the Task table, this works fine. I am just confused...

Thanks, yes, I tried to associate the autonumber field from the IFA table, to the IFA field on the task table, on a one to many basis, but when I do this I get a message saying that "Relationship must be on the same number of fields with the same data types". I know there is a simple answer...

This is probably a better visual

Good morning all, from an absolute noob. I am butchering the downloadable Task Manager available as standard with Acces 2016. I have created a table with a list of clients (named IFA), and populated the table with the names of the IFA's, and created a field in the task table, so that I can...

The strangest thing. I renamed the file to put on here for you to look at, and its now working? Thank you for your offer of help, if it breaks again I'll put it up on here.

Thanks DBguy, I wish I understood what you are saying! Sorry, im a total numpty. Should I delete the If statement?

Can anyone help? I'm clearly an amateur and know next to no VBA or SQL. The problem occurs with a main form, with many records, and I have a text box to open another form to view the full details of the current record. It works, and then when I shut down the DB and go back in, I get the...