search form

[slimjen]

All, I am working in a 2003 database. I have a form with a subform. There is an unbound field to select a tracking number that pulls up all the cooresponding records in the subform. I created an alternative search on the sales number to pull up the cooresponding records in the subform if I didn't have a tracking number. It's not working and I've been trying for two hours to get this right. When I search google on "searching the field, I only get help when the subform is already populated with records and just need filtering.

Why does the combo box work for the tracking number and not the sales number? The tracking number is used as a link child for the subform but it's also an unbound field to search. I cant figure this out and I know its really simple.
Please help.


Thanks

[Bob Fitz]

Can you post a copy of the db

[alansidman]

Cross Post

http://www.access-programmers.co.uk/...d.php?t=225447

[slimjen]

duly noted on the crosspost. I will try to scale down and post a sample. thanks

[slimjen]

pls see attached sample. I am to search the tracking number but not the pronum. The name of the form is frmLTRUCKLOAD. Any input would be appreciated.
Thanks