combo boxes to filter a form

  • Thread starter Thread starter errin
  • Start date Start date
E

errin

Hi All,
I am trying to incorporate three cascading combo boxes onto my form
that the user can use to selct a specific form to ecit or verify data
entered.
I have spent a lot of time working on this and have tried a lot of
suggestions from other posts, but have failed.
The first combo box is based on the Primary Key in TblSegments (field
named SegmentID) and the second two are based on the fields StartDate
and EndDate in TblEvents.
I would appreciate any help in writing code for these cascading boxes.
Thanks again.
EKW
 
I am trying to incorporate three cascading
combo boxes onto my form that the user
can use to selct a specific form to ecit or
verify data entered.
Click to expand...
I have spent a lot of time working on this
and have tried a lot of suggestions from
other posts, but have failed.
The first combo box is based on the Primary
Key in TblSegments (field named SegmentID)
and the second two are based on the fields
StartDate and EndDate in TblEvents.
Click to expand...
I would appreciate any help in writing code
for these cascading boxes.
Click to expand...

You did not explain to us the relationship between tblSegments and
tblEvents, nor how the ComboBoxes are related one to another, or what the
result should be, so it would be really miraculous if anyone were to be able
to write code for you. If you could clarify just a bit, you would greatly
increase the probability that someone might be able to make a useful
suggestion.

Larry Linson
Microsoft Access MVP
 
Sorry for not being clear enough. I am obviously new to Access and
didn't know how much detail was needed.
tblSegments is related to tblEvents in a one to many relationship where
SegmentID is the PK for tblSegments and a FK in tblEvents.
I would like for the cascading combo boxes to be used to select a
specific record on a Form (so that they can go back to edit a specific
event) that I have already created. This form is where the user enters
all info for a specific event including SegmentID,Start/End Date and
the details of that event. This form is called frmMainForm.
So my hope would be that the user could select a SegmentID (from
tblSegments) from the first combo box and then the choices in the
StartDate combo box would be limited to only those dates that are for
that segment and then the combo box for EndDate would be limited based
on the previous (both StartDate and EndDate are fields in tblEvents).
Once they have selected all three I would like for the form to go to
that specific record that they have chosen by specifying these three
fields.
I hope that this helps.
Thanks for your reply.
EKW
 
Back
Top