Cbo to do the same look-up

[stefan]

I have two forms with a cbo on each. The cbos looks up the
same field on the same table. However, the first form
concerns project start-up with cbo looking-up the project
sponsor. The second form concerns project completion and
the cbo should look-up who endorsed the project
completion. Usually, the project sponsor and endorser are
the same entity. However, a project could span for one
year and I don't want the project sponsor's name to appear
in the completion form cbo before completion.
How can I get the cbo to look up the same information on
the same table, but force the database user to input the
endorser's name when the project has completed and not
before (ie. when project starts with a known sponsor)?
thanks

 

[Jeff Boyce]

Stefan

Without any idea what your data is structured like, I have no idea how to
tell the difference between a project sponsor and a project completion
endorser. And if you are storing these two in "the same field on the same
table", how can YOU tell the difference?

More info, please...

Jeff Boyce
<Access MVP>

 

[Guest]

Apologies for the lack of detail and I hope the following
helps clarify my query.

What I have is a database which stores all information for
research projects which we manage and which we subcontract
to research consultants.

Within our company, the idea for a research project is
generated from an individual - what I call the project
sponsor.

The project is then subcontracted by a tendering process.
All research work completed by the chosen subcontractor
through to completion is stored on the database. When the
subcontractor's final report is approved, usually by the
project sponsor, but not always, then the project is
completed.

Therefore, I have a form (based on tblProject) with a cbo
which looks-up a table of individuals (tblsponsors) from
within our company. The user can choose from this table
and the info is recorded on the form.

I have another form for project completion (based on
tblProject) with a cbo which looks-up the same individuals
on tblsponsors - but I want to call these individuals the
project endorsers.

What I want to be able to do is include the info about the
sponsor when the project starts. When the project is
completed, I then want to include the info about the
project endorser.

But currently, when I enter the project sponsor, the
project endorser is also included, even though the project
is not completed and the endorser may be different to the
sponsor.

Maybe there is a better way of undertaking this task and
I'd be grateful for any advice
thanks

 

[Jeff Boyce]

Stefan

How many fields in your tblProject are used for the sponsor and endorser?
Which of these fields is bound to the field your are using when

But currently, when I enter the project sponsor, the
project endorser is also included, even though the project
is not completed and the endorser may be different to the
sponsor.

Since you mentioned that the list is based on a lookup table of employees, I
don't understand how "both sponsor and endorser" can be included. Included
where? In the combo box? In the form? On the tblProject?

Still more info, please...

Jeff Boyce
<Access MVP>