search form - complex

[JaredNJames]

hi, i have a form with three unbound fields, now i want it so that the user enters information into either one, two or all of them and then presses a button and it searches a table and retrieves the relevant data.

basically;
[invoiceid], [carregistration], [customername]

the user can enter into any or all of these and then press search to open another form which displays a full record based on the data.

how exactly would i go about this?

jared james

 

[pbaldy]

The sample db here demonstrates one method:

http://www.mdbmakers.com/forums/showthread.php?t=4895

 

[JaredNJames]

isnt there a simpler code that could be used? i dont really want to be doing all that for such a simple operation, particularly when im not that good with coding.

 

[boblarson]

isnt there a simpler code that could be used? i dont really want to be doing all that for such a simple operation, particularly when im not that good with coding.

What may SEEM simple on the surface isn't necessarily so when it comes to development. Also, I just looked at the coding there and that is not all that much in the development world. I know it can seem daunting if you haven't been doing it, but you have to realize that development is really doing a lot of work to make the user experience better.

A lot of times it takes a lot of work as the developer to do something which makes the users think it's a snap.