hope someone can help me with this.
I have a table of data that comprises a bunch of customer data that we need to call each day. At the moment the list from the table of customer details is printed off and passed round a team of 6 for each agent to use as their work sheet for the day. I'd like to change this so that, in a multi user environment, we have a form displayed that shows the customer details on the screen and allows the user to record outcomes etc. effectively editing the record
That's all working well and have no concerns about collecting data and storing it back etc. BUT if I open the form on my PC the customer record shows as i hoped it would. However if one of my colleagues opens the form on their screen at the same time, we both see the same record.
I have put a record lock on the form properties for "edited record" but on its own this doesn't seem to help. At the moment we are both simply opening the form from the side bar of all Access objects list.
As we move forward and before release to the agents, I will be creating a command button on a Welcome form with "give me the next record" on it (or similar). Is there some code i should add to this button that will open the form and display data based on the next unlocked record in the table? Hopefully that makes sense.
should add that at the moment the database is not split, not sure if that matters.
Many thanks in advance
I have a table of data that comprises a bunch of customer data that we need to call each day. At the moment the list from the table of customer details is printed off and passed round a team of 6 for each agent to use as their work sheet for the day. I'd like to change this so that, in a multi user environment, we have a form displayed that shows the customer details on the screen and allows the user to record outcomes etc. effectively editing the record
That's all working well and have no concerns about collecting data and storing it back etc. BUT if I open the form on my PC the customer record shows as i hoped it would. However if one of my colleagues opens the form on their screen at the same time, we both see the same record.
I have put a record lock on the form properties for "edited record" but on its own this doesn't seem to help. At the moment we are both simply opening the form from the side bar of all Access objects list.
As we move forward and before release to the agents, I will be creating a command button on a Welcome form with "give me the next record" on it (or similar). Is there some code i should add to this button that will open the form and display data based on the next unlocked record in the table? Hopefully that makes sense.
should add that at the moment the database is not split, not sure if that matters.
Many thanks in advance
Last edited: