Search results

Thanks for your response Pyro I'm using SQL to update it already... it's a subform, but wouldn't think that would affect it (I know that the control on the subform would need to be referred to like so: Forms![main form name]![subform control name].Form![control name]). I'll check over the...

Hello I’ve got a continuous form which lists different types of tasks This form is built on a query that uses UNIONs to merge tables values with identical column names. There is a button on the form to update the task status, when this is clicked, some vba runs to figure out which table...

I've edited my initial post and attached a zip with an image which shows the relationships I've attempted to describe.

I have a table “tblRequest” which will be used to track requests in our team. A request can relate to many tasks/actions and an action can relate to many requests. I have created a table which links actions - “tblLnkAction” - and in this table are also some fields (date completed, date...

Hello, We use Access in work to manage our workload. The database was set up originally by someone who left the team soon after. I did a short three day course in Access which went over the basics (although it really glossed over many to many / one to many relationships). I've used what I've...