I have an Access 2002 database running off SQL 2K advance server back end. Within this database I need to have column A (example column or field A) upon selection of a specific criteria have column B or field B become a automatically filled column with whatever criteria I specify. Basically making that field a field that can not be edited based off the crieteria in field A otherwise you can change it or modify for all other reason or choices. So my question how do I do this in Access or SQL, which ever is easier? Help!

Could you clarify? You lost me in there, somewhere.

And, where do you want this all to happen -- in a Form, in a Query, or ????

With a little more detail, someone can likely offer a suggestion.

Larry Linson
Microsoft Access MVP

"uniquedb" <(E-Mail Removed)> wrote in message
news:6B3D5A69-1E9F-4B23-832F-(E-Mail Removed)...
> I have an Access 2002 database running off SQL 2K advance server back end.
Within this database I need to have column A (example column or field A)
upon selection of a specific criteria have column B or field B become a
automatically filled column with whatever criteria I specify. Basically
making that field a field that can not be edited based off the crieteria in
field A otherwise you can change it or modify for all other reason or
choices. So my question how do I do this in Access or SQL, which ever is
easier? Help!
>

If I understand you correctly, you can:
1. Make the ControlSource of a combo box (cboA) on your
form tied to field A.
2. Make a text box (txtB) on your form that is unbound.
3. In the AfterUpdate event procedure in cboA, use a SQL
query like "SELECT FieldB FROM Table1 WHERE FieldA='" &
cboA & "'" to get the correct value from FieldB.
4. Set the text box txtB to the value from the SQL query.


>-----Original Message-----
>I have an Access 2002 database running off SQL 2K advance
server back end. Within this database I need to have
column A (example column or field A) upon selection of a
specific criteria have column B or field B become a
automatically filled column with whatever criteria I
specify. Basically making that field a field that can not
be edited based off the crieteria in field A otherwise you
can change it or modify for all other reason or choices.
So my question how do I do this in Access or SQL, which
ever is easier? Help!
>
>.
>

I would like for this operation to happen on the form. When they open this database up via the form, there is a field that is tied to a table with a column of course, but within this column certain data information entered should be set to automatically fill column or field a but the data that I specify but make this field read only based off that criteria that I have defined. I would like have the operation that does this done in the design but have the users actually see the results of it on the form when the select it or choice that option. I hope this helps some.

If I do as you suggest, does that make the field that I have just made to auto populate become a read only type field or a field that the user can not edit based off that criteria?

----- Chuck Wood wrote: -----

If I understand you correctly, you can:
1. Make the ControlSource of a combo box (cboA) on your
form tied to field A.
2. Make a text box (txtB) on your form that is unbound.
3. In the AfterUpdate event procedure in cboA, use a SQL
query like "SELECT FieldB FROM Table1 WHERE FieldA='" &
cboA & "'" to get the correct value from FieldB.
4. Set the text box txtB to the value from the SQL query.


>-----Original Message-----
>I have an Access 2002 database running off SQL 2K advance
server back end. Within this database I need to have
column A (example column or field A) upon selection of a
specific criteria have column B or field B become a
automatically filled column with whatever criteria I
specify. Basically making that field a field that can not
be edited based off the crieteria in field A otherwise you
can change it or modify for all other reason or choices.
So my question how do I do this in Access or SQL, which
ever is easier? Help!
>>.
>