grobermatic
Technical User
Ok, I think that this should be pretty simple but I keep getting stuck!
I have a small form with a combo box at the top which holds a list of employee names. This is taken from a table which hold only these names (FLANames)
The idea is that the user will select an employees name and the continuous subform below will display a list of dates that the selected employee has worked. (from another table PerformanceInfo)
I was getting successful results until I changed the primary key to a combined primary key. This needs to remain.
I think the problem is that when I select the nane from the combo box, the form is trying to create a new record in the underlying table, an error is generated because the primary key is not being filled in for the new record.
I dont want to create a new record, I only want to lookup and select previousley entered records.
I tried changing the "DATA ENTRY" property to no but when I do this the form opens with records already displayed which I don't want.
I would be grateful for any help anyone could offer
Craig
I have a small form with a combo box at the top which holds a list of employee names. This is taken from a table which hold only these names (FLANames)
The idea is that the user will select an employees name and the continuous subform below will display a list of dates that the selected employee has worked. (from another table PerformanceInfo)
I was getting successful results until I changed the primary key to a combined primary key. This needs to remain.
I think the problem is that when I select the nane from the combo box, the form is trying to create a new record in the underlying table, an error is generated because the primary key is not being filled in for the new record.
I dont want to create a new record, I only want to lookup and select previousley entered records.
I tried changing the "DATA ENTRY" property to no but when I do this the form opens with records already displayed which I don't want.
I would be grateful for any help anyone could offer
Craig