need to automatically fill in yes no field in table

[waymond]

I have a table called company that has the following fields
ustID
company
company address
city
state
zip
state
sic no
actexport yes no field

i do not what to use a unbound text box form or just a regular query
the admin needs to pic the sic no which will always be more that one then the company form needs to be opened with the companies that match the code for export which an export query would then run with the above fields to a comma text delimited file for export into act. the companies that were selected for the export need to have the check marks in the yes no field so they can see the records of the companies they already exported.

thank you need a solution that will solve this nightmare

 

[PHV]

pic the sic no which will always be more that one
???
the companies that match the code for export
???

Can you please try to better explain what you want to do ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[waymond]

ok I miss worded the above
I need a solution that will solve this problem

when an admin selects the sic codes for a certain industry lets say they select 4999 I need a way without them going company by company to have the field called actexport automatically checked in the check box for that field in the company table.
I do not know the easiest and simplest way to do this. I do not know what to use to solve this whether it would be a query by form or something.

thank you

 

[PHV]

A query like this ?
UPDATE company SET actexport=True WHERE [sic no]=4999

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886