S
Scuda
Hello all, I have a little dilemma here.
On my main menu form (frmMainMenu) I have 2 unbound combo boxes. They
display 1) Recent incidents from 1 table (updated by 4 forms) and 2) a
running Chronological Log - 1 table (updated by 1 form). What I want to do is
be able top click on a specific record in my combo box and then be taken the
applicable form and entry.
I have seen something like this in another database that I worked, obviously
not created by me!
How can I accomplish this. Here is the code from my first combo box:
SELECT tblSENEIncidentLog2008.MONTH, tblSENEIncidentLog2008.DAY,
tblSENEIncidentLog2008.IncidentID, tblSENEIncidentLog2008.[SENE_CASE_#],
tblSENEIncidentLog2008.[NATURE OF DISTRESS], tblSENEIncidentLog2008.[Case
Description], tblSENEIncidentLog2008.[CASE STATUS]
FROM tblSENEIncidentLog2008
ORDER BY tblSENEIncidentLog2008.[SENE_CASE_#] DESC;
Thanks so much!
Steph
On my main menu form (frmMainMenu) I have 2 unbound combo boxes. They
display 1) Recent incidents from 1 table (updated by 4 forms) and 2) a
running Chronological Log - 1 table (updated by 1 form). What I want to do is
be able top click on a specific record in my combo box and then be taken the
applicable form and entry.
I have seen something like this in another database that I worked, obviously
not created by me!
How can I accomplish this. Here is the code from my first combo box:
SELECT tblSENEIncidentLog2008.MONTH, tblSENEIncidentLog2008.DAY,
tblSENEIncidentLog2008.IncidentID, tblSENEIncidentLog2008.[SENE_CASE_#],
tblSENEIncidentLog2008.[NATURE OF DISTRESS], tblSENEIncidentLog2008.[Case
Description], tblSENEIncidentLog2008.[CASE STATUS]
FROM tblSENEIncidentLog2008
ORDER BY tblSENEIncidentLog2008.[SENE_CASE_#] DESC;
Thanks so much!
Steph