How do I...

[Mozencrath]

I am creating a DB for a company. The company has thousands of customers therefore when adding an order or RFQ for a customer, my dropdown box to select the customer has thousands of entries. I'd like to be able to have a button that says "Add Order" and then takes me to a form or query that has a datasheet view of all the companies with a record select button next to each where I can then just click on the company and it takes me to the order entry form/modal. Thanks! Im hoping this can be done without too much or any code.

[Rod]

Yes, a datasheet has search and filtering capability built in that may be used to aid your identification of a customer. I don't know much about tables in datasheet view but a form view will 'point' to the current record (i.e. the one highlighted by the record selector) and make available all the values of the current record's fields (attributes). So it's easy to pass a customer key to your order/RFQ form.

First you need to build a datasheet view of the customer information that you wish to see. Make all the fields Enabled = No and Locked = Yes; you don't want to be able to change data here! Add an unbound text box before all the customer fields and go to Arrange/Tab Order/Auto Order to force the datasheet to display it at the left hand side of the form. At this time check the form, that you can navigate up and down, that you can sort it, that you can filter it.

When you're happy, repost and we'll take it a stage further.

[June7]

More than one way to approach this. For little or no code, open the Order form to New record or navigate to New record, select customer from combobox, enter other order information. If you set the Order form DataEntry property to Yes then the form will open only to New record. Anything else will require code.

[Rod]

June, I think Mozencrath's problem is that

... select customer from combobox, ...

action.

The company has thousands of customers therefore when adding an order or RFQ for a customer, my dropdown box to select the customer has thousands of entries.

[June7]

I use comboboxes with thousands of rows. With AutoExpand property set Yes, start typing the customer name or number and the combobox will fill with a matching value from the list. However, review http://allenbrowne.com/ser-32.html