Searching into a form

[iliast]

I have a form for "Deliveries". "ID"-"Delivery Number"-"Kind of delivery". A combo search-box I made allow me to find a record by the "ID". How can I do the same while I search for a record by "Delivery number"?

 

[rosito]

Open form in "Design view" ->click on "Delivery number" with right button -> then selsect "change to" -> "combo box"

 

[iliast]

unbelievable...so simple Mind if I'll ask u somethin' else?

 

[iliast]

And of course...ty!

 

[rosito]

 

[iliast]

I have a Search Form. Criteria are some combo boxes. The problem is that search process return me as results numbers (the IDs of the tables) and not names. Par example, if I give the option "Sunday" into the criteria field "Day", the result is "1" (the ID of "Day" table) and not "Sunday". How can I override that?

 

[iliast]

Rosito?...

 

[boblarson]

Can you post your db?

If you aren't sure how, look here first:

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[iliast]

Here is the db Bob

 

[iliast]

Another db due opening problems of the last (according to Rosito)