Neil.Cranston
New member
- Local time
- Today, 08:09
- Joined
- Jun 18, 2001
- Messages
- 6
I have two tables TblHardware & TblConnection I have created a query with all the fields from both tables and a left hand join between connection.
TblHardware TblConnection
Switch connection
Port Location
Connection Description
I am using the query and have bound it to a form, which I was expecting to be able to update the connections within the tables.
The Switch & Port are both primary keys, which I wanted to be able to select as one from a combo box, and use that to display the relevant connections details on the form. However I am having problems, when I select both primary keys the switch is stored but not the port. I get an error message:
“run-time error 2105, You can’t go to this specific record you may be at the end of the record set”
I take it that this is because there are no records which just have a switch, is there any way that I can select both primary keys in one go and then store them in separate columns?
I am using access 97.
Any suggestions will be more than welcome
cheers
Neil
TblHardware TblConnection
Switch connection
Port Location
Connection Description
I am using the query and have bound it to a form, which I was expecting to be able to update the connections within the tables.
The Switch & Port are both primary keys, which I wanted to be able to select as one from a combo box, and use that to display the relevant connections details on the form. However I am having problems, when I select both primary keys the switch is stored but not the port. I get an error message:
“run-time error 2105, You can’t go to this specific record you may be at the end of the record set”
I take it that this is because there are no records which just have a switch, is there any way that I can select both primary keys in one go and then store them in separate columns?
I am using access 97.
Any suggestions will be more than welcome
cheers
Neil
