Auto populate cbo based on other cbo if that cbo value exists in t

H

Hugh self taught

Hi Clever people,

My mind has left me (Long ago actually)

I have a form with several cbo's of which one (EvtNumber) will add a record
if NotInList. The other in question is EvtStruct.

While I am adding data sequentially I have a procedure that auto populates
certain cbo fields with the data from the previous input record. Of which
these mentioned here are included. That bit all works wonderfully Except...
(like a large BUT ...) when I have to use an event number that I've
previously finished inputting & have to add another record for the same
event. The related table has a PK EvtInput_Idx but there are multiple records
with the same EvtNumber for which I use TOP 1 as part of my SQL to get the
EvtNumber.

My question is then how do I auto populate the Me!EvtStruct cbo when I
select the EvtNumber if there are any existing records in the tblEvtInput
table with that EvtNumber?
 
Top