Another Check Mark Question

[Porkchop]

New Check mark question
On a sub form. I have put a Check Mark to copy text from 5 text boxes to 5
other text boxes. But this time the subform is accessing tables in a
different way.

Here is what the control source is set to.
SELECT [manifest info].[Manifest No], [manifest info].[Generator Name],
[manifest info].[Generator Address], [manifest info].[Generator City],
[manifest info].[Generator State], [manifest info].[Generator Zip],
[manifest info].[Origin Facility], [manifest info].[Origin Facility
Address], [manifest info].[Origin Facility City], [manifest info].[Origin
Facility State], [manifest info].[Origin Facility Zip], [manifest
info].Description, [manifest info].[Ticket Number] FROM [manifest info]
ORDER BY [manifest info].[Manifest No];



The first form that you folks helped me with was simple. The control source
was set to [manifest info] with out the brakets. So when you had me bind the
check mark to a field in a table [manifest info] was the correct table.
Easy! Now I can't seem to bind this Check Mark.

The error I get is: can't bind to an unknown field: "manifest info"



Help!

If you need more info, I'll be happy to supply it.

Thanks

Porkchop

 

[Allen Browne]

You cannot use the name of the table as the Control Source of a control.
Use the name of the field.

BTW, if you are drawing all the fields from one table, you can just use a
RecordSource of:
SELECT [manifest info].*
FROM [manifest info]
ORDER BY [manifest info].[Manifest No];

 

[Porkchop]

I actually figured it out. I needed to add [manifest info].test to the
select statement. That is because, we where being specific to what was being
selected out of the table, I missed the field that I was binding the check
mark to. Once I included that field, it worked.

Just thought maybe I would pass that along.
Porkchop

 

[live.com]

I actually figured it out. I needed to add [manifest info].test to the
select statement. That is because, we where being specific to what was
being selected out of the table, I missed the field that I was binding the
check mark to. Once I included that field, it worked.

Just thought maybe I would pass that along.
Porkchop

New Check mark question
On a sub form. I have put a Check Mark to copy text from 5 text boxes to
5 other text boxes. But this time the subform is accessing tables in a
different way.

Here is what the control source is set to.
SELECT [manifest info].[Manifest No], [manifest info].[Generator Name],
[manifest info].[Generator Address], [manifest info].[Generator City],
[manifest info].[Generator State], [manifest info].[Generator Zip],
[manifest info].[Origin Facility], [manifest info].[Origin Facility
Address], [manifest info].[Origin Facility City], [manifest info].[Origin
Facility State], [manifest info].[Origin Facility Zip], [manifest
info].Description, [manifest info].[Ticket Number] FROM [manifest info]
ORDER BY [manifest info].[Manifest No];



The first form that you folks helped me with was simple. The control
source was set to [manifest info] with out the brakets. So when you had
me bind the check mark to a field in a table [manifest info] was the
correct table. Easy! Now I can't seem to bind this Check Mark.

The error I get is: can't bind to an unknown field: "manifest info"



Help!

If you need more info, I'll be happy to supply it.

Thanks

Porkchop