S
souchie40
This problem is driving me crackers and I would appreciate any suggestions
and help that anybody supplies. My proble is that my query is based on two
tables one which as a multiple number of combo boxes to populate repetative
fields, now each combo box ROWSOURCE is based on SELECT DISTINCTROW SQL
statement, each time I open the form to populate the data I get the foloowing
error message: -
The Microsoft Jet database engine cannot find the input table or query
SELECT DISTINCTROW[Planned Procurement].[ID], [Planned Procurement].[Ship
Class] FROM[Planned Procurement] Make sure it exists and that its name is
spelled correctly.
All the record sets and varibles in the control forms are set to read
identical values.
If I click ok the form opens with missing data from the completed records,
if I then switch to design view and switch back as if by magic my data comes
back and I can carry on creating new records wich is fine for me but I don't
want anyone having access to the DB window owhen I roll this out.
Many Thanks in advance
and help that anybody supplies. My proble is that my query is based on two
tables one which as a multiple number of combo boxes to populate repetative
fields, now each combo box ROWSOURCE is based on SELECT DISTINCTROW SQL
statement, each time I open the form to populate the data I get the foloowing
error message: -
The Microsoft Jet database engine cannot find the input table or query
SELECT DISTINCTROW[Planned Procurement].[ID], [Planned Procurement].[Ship
Class] FROM[Planned Procurement] Make sure it exists and that its name is
spelled correctly.
All the record sets and varibles in the control forms are set to read
identical values.
If I click ok the form opens with missing data from the completed records,
if I then switch to design view and switch back as if by magic my data comes
back and I can carry on creating new records wich is fine for me but I don't
want anyone having access to the DB window owhen I roll this out.
Many Thanks in advance