Looking for a Better Way

[AccessAmateur]

I have a form open in datasheet view, the user is to select the record wanted & double click. On double click I want to pop up a box like a message box which gives the user a choice of three or four options similar to an option group box.
The form is open in datasheet view so I can't use an option group. What can I use??
Thanks

 

[George Too]

How about having the user enter a number. For example, If user wants option 1 then he/she will enter "1" in the appropriate field. And so on...

Hope lights the way

George

 

[Pat Hartman]

Use a combobox.

 

[AccessAmateur]

Problem with using a combo box is that it does not show up in Datasheet view. I am not trying to update data in this table.
The records are addresses. The use selects the record desired, then double clicks on the Address_Code number field, then I want a dialog box to pop up which offers the choice of: Bill to this address. Ship to this address . Ship to and bill to this address. or Cancel.
This could be done by putting the addresses in a Combo box for each of the bill to and ship to addresses but then the user can only search for the desired address by the Address Code (which he probably doesn't know) or by scrolling the list. This is why I'm using DS view. In datasheet view the user can do the full range of filters & searches. I have set it up already to do each of the bill to and ship to addresses separately but this means the user MUST repeat the search for each address even though they are often the same so I am looking for a convenient method do both addresses at once.
Any ideas?

 

[Pat Hartman]

The combobox does show up in datasheet view. It works just fine. If as you said, you want to pop up a message box with options, you'll need to build your own form to do that. Just add the OpenForm code to the double click event of some field of the form.