Change combo box rowsource on add record

[Klingon Coder]

Hi, I'm hoping someone can help me out on this problem.

I have two tables, one that stores information about RFPs that a company has
received. In this table there is a field to indicate if the company has
decided to place a bid on the RFP. The second table stores information about
any proposals that the company has submitted. Both tables are related by the
requisition number from the RFP table. I have a form that is used to display
the information on the proposals (the record source is a query named
qryProposal). On this form I have a combo box (cboReqNum) which displays
only those records that have been assigned a proposal number (the primary key
for the proposal table). I have a second query (qryProposalNoBid) which
displays a list of RFPs that the company has bid on, but haven't yet been
assigned a proposal number (in effect potential records).

What I am trying to accomplish is to have the form use the qryProposal as
its record source except when a new record is added, in which case I want it
to use qryProposalNoBid, so that when the user clicks on the combo box they
are given a list of available Requisition numbers, instead of the completed
ones. Once the record has been added I want to revert back to the
qryProposal.

My problem is that I can't seem to figure out which event to use or the
syntax required to accomplish this. Any help in this matter would be greatly
appreciated.

--
Cheers

Klingon Coder

"Ancient Klingon Proverb - Act and you shall have dinner, Think and you
shall be dinner"