Updating a check box based on a complicated relationship.

[Jaaz]

Essentially I'm constructing a database to track a lot of data. Part of
this included a running history table that is linked to data outside
the table. On the main form I used, I've hit a snag.

I want to be able to show on the form if the company entered (each
w/different ID tag) and the table holding info regarding licenses
(linked through company's ID) has the 'active' checked, when it is
filtered by the project number just entered into the previous box.

Linking the query that tells me the info I need for the control makes
the Query records, and thus the form, unupdateable. I need to figure
out how to do this for display purposes, and also how to tie that
result into other queries that are run based on if the company, active
license, and project number intersect to create a project-specific
Yes/No type answer that doesn't lock records.

Help!

[Bob Quintal]

"Jaaz" <Ja****@gmail.com> wrote in
news:11*********************@v46g2000cwv.googlegro ups.com:

Essentially I'm constructing a database to track a lot of
data. Part of this included a running history table that is
linked to data outside the table. On the main form I used,
I've hit a snag.

I want to be able to show on the form if the company entered
(each w/different ID tag) and the table holding info regarding
licenses (linked through company's ID) has the 'active'
checked, when it is filtered by the project number just
entered into the previous box.

Linking the query that tells me the info I need for the
control makes the Query records, and thus the form,
unupdateable. I need to figure out how to do this for display
purposes, and also how to tie that result into other queries
that are run based on if the company, active license, and
project number intersect to create a project-specific Yes/No
type answer that doesn't lock records.

Help!

You should be able to retrieve the checkbox's value using a
DLookup() or a user-defined function in the query, or to an
unbound control on the form itself..

--
Bob Quintal

PA is y I've altered my email address.

[Jaaz]

Thanks! I looked it up and looks like it'll do exactly what I need come
Monday. Still learning VB I guess.