Recordlookup and selection

[mlozano]

Hi
I have a db for quotes, orders, packing lists, invoices etc.

I want to avoid the use of combo boxes where avoidable.

Whar I would like to do is the following:

Take for instance a "new order" form.To select the customer, users would
1.- Double click on the "Customer" field, which would open the "Customers" form in datasheet view or continuous forms view.
2.- Filter or seartch to find the intended customer
3.- Double click on the desired customer id or name fields,which would close the "Customers" form and set the value of the "Customer" field of the "New Order" form to the key of the selected customer

Very much like in MS Dynamics NAVand many other business apps.

Is this possible without a lot of code?
Any help would be greatly appreciated

Cheers!

[pbaldy]

Personally I'd use a combo, but you could adapt this to create a pop up form that could be called from anywhere.

http://www.baldyweb.com/WrappedForm.htm

[June7]

Why avoid combobox? Have the "Customer" field be a combobox on form. Select customer from the list. Enter order information. Zero code required. The combobox would be multi-column. Review: http://datapigtechnologies.com/flash...combobox3.html

[Missinglinq]

Using the 'song-and-dance' routine you've described, to accomplish this very routine task, instead of using a Combobox, is, to be perfectly blunt, simply absurd! A Combobox will automate 75% of what you've described here, with the other 25% taking ten or fifteen minutes of work!

What, exactly, is your objection to Comboboxes?

Linq ;0)>

[mlozano]

I have no propblem whatsover with combo boxes when there are not too many records to select from.
My "Customers" table would have thousands of records.
I prefer a popup because the form could be filtered according to different parameters to narrow the search.
Thanks

[pbaldy]

Did the wrapped form idea help?