search records by 2 fields in combo box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a scheduling database I'm building and my problem is this. I put a
combo box on the form to look up specific records. If the Client only has
one even on that date it works fine. However, If a client has multiple events
on the same date, the combo box will only show the first record for that
date. The fields I have showing in the combo box for the search are "Client
Name, Event Date, Event Start and ID" (which is that records autonumber ID)
It's my hope to find a way to see those four fields and when I click on the
correct Client/Date/Event Start/ID the search will find the Client Name and
ID and Update the form to that specific record. Thanks in advance!
 
I have a scheduling database I'm building and my problem is this. I put a
combo box on the form to look up specific records. If the Client only has
one even on that date it works fine. However, If a client has multiple events
on the same date, the combo box will only show the first record for that
date. The fields I have showing in the combo box for the search are "Client
Name, Event Date, Event Start and ID" (which is that records autonumber ID)
It's my hope to find a way to see those four fields and when I click on the
correct Client/Date/Event Start/ID the search will find the Client Name and
ID and Update the form to that specific record. Thanks in advance!
Click to expand...

If the Bound Column of the combo box is the unique ID, and if you use
the Combo Box Wizard using the "use this combo to find a record", this
should work. Just display the first three fields in the combo and
select the desired one.

If the fields [Date] and [Event start] contain the event date and
event time, you may want to consider just using one Date/Time field
instead.

John W. Vinson[MVP]
 
Back
Top