Find Box Problem?

[Randy]

I have set up two Find Boxes on a Tab form. The first one works fine.
When I select from the list it goes right to the case. On the second
Find Box when I select from the list it does nothing, just sits there.
If I hit enter it goes to the wrong case.

Can you have two find boxes on a tab form? What do I need to do to fix
it?

Thanks for any help

 

[Jeff Boyce]

How?

How did you "set up two 'Find Boxes'"? What are the row sources?

What's the code behind the form? What's the code supposed to do in the
AfterUpdate event of the second?

More info, please!

Jeff Boyce
<Access MVP>

 

[Randy]

I just set up two separate Combo Boxes using the Combo Box button. One
Combo box brings up the last name and first name. The second Combo box
brings up the case number. Again I just used the Combo Box button.

When I click on the first combo box it brings up a list of client
names. When I bring up the case number it brings up a list of case
numbers.

The form is just the main form based on the main table.

The combo box's are just suppose to bring up the records based on the
record I select in the combo box.

 

[Randy]

I just set up two separate Combo Boxes using the Combo Box button. One
Combo box brings up the last name and first name. The second Combo box
brings up the case number. Again I just used the Combo Box button.

When I click on the first combo box it brings up a list of client
names. When I bring up the case number it brings up a list of case
numbers.

The form is just the main form based on the main table.

The combo box's are just suppose to bring up the records based on the
record I select in the combo box.

 

[Jeff Boyce]

But how? How are the combo boxes supposed to do that? What code do they
have in their AfterUpdate event that would tell Access to find the related
record?

And I'm confused by your having two combo boxes, one for person, one for
case.

Are you saying that each person can have any/all of the case numbers?! I
would have thought that selecting a person in the first combo box should
cause the second combo box to re-query, finding ONLY the case numbers
belonging to the selected person... (this is called "cascading combo
boxes", in case you want to look it up).

Good luck

Jeff Boyce
<Access MVP>

 

[Randy]

Jeff all I want the combo boxes to do is bring up the record. I was
giving the workers two choices either to pull up the data by name or by
case number. Whenever clients come in to the office they may have
changed their name because they got married so by having a choice you
can be more accurate or do a double check. Sometimes its easier to be
more accurate with a number than the name also as staff can mispell the
name so again the choices help to be more accurate.

I don't know code as I am new to Access. If it won't work with two
combo find boxes I just need to know that.

 

[Jeff Boyce]

Randy

I may have missed that part about choices...

Yes, you could use more than one combo box to look up a record.

It would still help if you would provide the SQL statement that runs in your
AfterUpdate event for each of the combo boxes.

The generic process is:

* you make a selection from a combo box that holds at least a recordID
and the user-friendly value that the user is selecting.
* your combo box has code in the AfterUpdate event that either re-queries
the form, using the selected value, or filters the form, using the selected
value.

If these concepts are new to you, plan to spend some time studying them --
they'll pay off now and later!

Good luck

Jeff Boyce
<Access MVP>