P
p-rat
I have a payroll form. Six of the nine fields are autofilled from a
query. The scenario is that clerks enter in Work Tickets for the
previous days work. There is pay information on these tickets. I query
the work tickets for any pay information and then autofill the payroll
form. My problem is that if there are three records returned from the
query on the payroll form the clerk will choose the LineNumber to
autofill. Choosing from a combo box LineNumber one will fill in the
first line from the query. The clerk will then tab to several fields
that don't come from the query. The next row the clerk will choose the
next line number and it will autofill those fields from the query.
Strange thing is that there are 6 columns being autofilled:
WorkTicket#,Date,EmployeeNumber,EmployeeName,JobTitle,Hours.......
all fill correctly except for the WorkTicket# and Date.
On these two if I, for example, choose LineNumber 1 from combo box
(suppose to return and autofill first record of query) it's fine. On
the next line if I choose LineNumber 2 from combo box the first row or
records WorkTicket# and Date will change to whatever the LineNumber 2
WorkTicket# or Date fields are???
The rest of the fields stay without changing.
The code looks the same for all fields and the query looks good. I
don't know what is going on. Thanks.
query. The scenario is that clerks enter in Work Tickets for the
previous days work. There is pay information on these tickets. I query
the work tickets for any pay information and then autofill the payroll
form. My problem is that if there are three records returned from the
query on the payroll form the clerk will choose the LineNumber to
autofill. Choosing from a combo box LineNumber one will fill in the
first line from the query. The clerk will then tab to several fields
that don't come from the query. The next row the clerk will choose the
next line number and it will autofill those fields from the query.
Strange thing is that there are 6 columns being autofilled:
WorkTicket#,Date,EmployeeNumber,EmployeeName,JobTitle,Hours.......
all fill correctly except for the WorkTicket# and Date.
On these two if I, for example, choose LineNumber 1 from combo box
(suppose to return and autofill first record of query) it's fine. On
the next line if I choose LineNumber 2 from combo box the first row or
records WorkTicket# and Date will change to whatever the LineNumber 2
WorkTicket# or Date fields are???
The rest of the fields stay without changing.
The code looks the same for all fields and the query looks good. I
don't know what is going on. Thanks.