Guest_imported
New member
- Jan 1, 1970
- 0
Hello,
I have created an Access Timesheet system where users input their weekly
hours and expenses into a form. The form has two subforms, one for hours and
one for expenses. The entries are recorded by Project, so in the subform
there are client code and project code fields. They are both combo boxes and
the project code combo box is updated after the client is selected to only
offer that client's projects as options. When you first try to choose a
project the following message appears: "Can't find input table or query
#sq_cTimeCardsSubform~sq_cProjectCodeHrs' Make sure it exists and that its
name is spelled correctly."
However if you open the datasheet view of the timecard subform, click a
couple of combo boxes and select the project, then go back to the original
form - you can select a project from the combo box without any problems.
Any ideas?
Cheers
Kate [sig][/sig]
I have created an Access Timesheet system where users input their weekly
hours and expenses into a form. The form has two subforms, one for hours and
one for expenses. The entries are recorded by Project, so in the subform
there are client code and project code fields. They are both combo boxes and
the project code combo box is updated after the client is selected to only
offer that client's projects as options. When you first try to choose a
project the following message appears: "Can't find input table or query
#sq_cTimeCardsSubform~sq_cProjectCodeHrs' Make sure it exists and that its
name is spelled correctly."
However if you open the datasheet view of the timecard subform, click a
couple of combo boxes and select the project, then go back to the original
form - you can select a project from the combo box without any problems.
Any ideas?
Cheers
Kate [sig][/sig]
