N
NoviceIan
I basically have a list box of all employees which allows staff numbers to be
looked up. When a staff member is selected the relevant staff number is
stored in a the staff number field on the form.
I have done this because i had difficulties linking the list box with a sub
form. The idea being a staff member is selected and then the sub form
displays mileage details which can be cycled through. There is no staff
number field on the sub form.
The problem I have is if there are 7 records and and click next 8 times and
hit a blank form the next time I view that persons mileage claims they have a
new one which has been stolen from another employee.
I have no idea what to do. I got the idea from the 'Northwind' sample
database. Please help
looked up. When a staff member is selected the relevant staff number is
stored in a the staff number field on the form.
I have done this because i had difficulties linking the list box with a sub
form. The idea being a staff member is selected and then the sub form
displays mileage details which can be cycled through. There is no staff
number field on the sub form.
The problem I have is if there are 7 records and and click next 8 times and
hit a blank form the next time I view that persons mileage claims they have a
new one which has been stolen from another employee.
I have no idea what to do. I got the idea from the 'Northwind' sample
database. Please help