indesisiv
Access - What's that?
- Local time
- Today, 22:31
- Joined
- Jun 13, 2002
- Messages
- 265
I will try and explain the situation:
1. I have a main form that the user inputs details .. all works fine
2. The user clicks a button to add / edit / view (depending on the selection) details in a linked form.
3. Viewing the details is fine. There is a box at the top that is populated fron the main form and then it uses a selection in a combo box to bring up the details .. this all works fine
4. The problem is when i come to add the details in.
There is a duel primary key made up of UnitName & Service
Unit name is autoselected so that it refers to the main form. The service is in a combo box that the user selects. BUT!!! Onlyafter you try and update the record it tells you that you have a duplicate primary key.... What it NEEDS to do is ... when the service is selected from the combo box if there is already a record in then it needs to be shown on the screen so that it can be edited. If there is not a record that maches then the user can just carry on and make one.
Hope that all makes sense.
Any help will be gratefully recieved
Steve
1. I have a main form that the user inputs details .. all works fine
2. The user clicks a button to add / edit / view (depending on the selection) details in a linked form.
3. Viewing the details is fine. There is a box at the top that is populated fron the main form and then it uses a selection in a combo box to bring up the details .. this all works fine
4. The problem is when i come to add the details in.
There is a duel primary key made up of UnitName & Service
Unit name is autoselected so that it refers to the main form. The service is in a combo box that the user selects. BUT!!! Onlyafter you try and update the record it tells you that you have a duplicate primary key.... What it NEEDS to do is ... when the service is selected from the combo box if there is already a record in then it needs to be shown on the screen so that it can be edited. If there is not a record that maches then the user can just carry on and make one.
Hope that all makes sense.
Any help will be gratefully recieved
Steve