Expression Builder

T

tcorlew

We are a repair company and we frequently receive jobs that we have done in
the past. We track them by the serial numbers. I would like to have a drop
down box that displays all the previous jobs for that part. The only
expressions I can find display a set value and I need something that will
search for an equal value for that job only. Any help??
 
A

Al Camp

I would use a combo box to enter a SerNo, and then a second combo box
would list all jobs that used that SerNo
Set up the first combo (ex. cboSerNo) to diplay all the SerNos that have
been used in the past.
Create a second combo (cboJobs), and use the value from cboSerNo to
filter out all the records that don't have the cboSerNo value. cboJob
should have 2 fields... JobNo and SerNo, and the SerNo should have a
criteria of...
=Forms!YourFormName!cboSerNo
Use the AfterUpdate event of cboSerNo to Requery cboJobs so they will
always be in synch.
hth
Al Camp
 
T

tcorlew

Will the first combo box allow me to enter in new serial numbers if that
particular one doesn't already exist.

Also, is their a way to may the text predictive so we don't have to scroll
all the way until we find the correct serial number cause they are up into
the thousands now.
 
A

Al Camp

I'm not sure why you'd want to do that. From your description, the idea is
to find jobs that used a particular SerNo, so entering a SerNo that has
never existed doesn't seem to make sense.
But...
You can set the cboSerNo LimitToList property to = No, and that would allow
you to enter a SerNo that has never existed, but then cboJobs won't yield
any results.

hth
Al Camp
 
Top