I have a few queries that no longer seem to recognize the info selected from a text box on a form .
Here is the way I had it set up. It's an append query to add the info to a table to be used later in a report.
They worked well for over a year and suddenly this week when I run the query these two items come up as a parater looking for an input.
I haven't made any changes that I can think of to cause this. I have added a few new buttons on the form for other tasks. (a couple of hyperlinks)
Any advice would be appreciated. I did try to use the builder and recreate the field but no luck.
Driver: [Forms]![Drivers Daily Payroll Info]![Drivers Name]
Date: [Forms]![Drivers Daily Payroll Info]![Start Date]
Here is the way I had it set up. It's an append query to add the info to a table to be used later in a report.
They worked well for over a year and suddenly this week when I run the query these two items come up as a parater looking for an input.
I haven't made any changes that I can think of to cause this. I have added a few new buttons on the form for other tasks. (a couple of hyperlinks)
Any advice would be appreciated. I did try to use the builder and recreate the field but no luck.
Driver: [Forms]![Drivers Daily Payroll Info]![Drivers Name]
Date: [Forms]![Drivers Daily Payroll Info]![Start Date]