Dick7Access
Dick S
- Local time
- Today, 05:37
- Joined
- Jun 9, 2009
- Messages
- 4,201
Is it possible to get a combo box to work in datasheet view?
Thanks for answering. combo works in form view, but not on datasheet view. Now my form is a subform and opens in datasheet view. Does that make a differenceOf course. Why, what's happening with your combobox?
Hi. I just gave it a try, and it seems to work fine for me.Thanks for answering. combo works in form view, but not on datasheet view. Now my form is a subform and opens in datasheet view. Does that make a difference
Thanks, I will go over my code.Hi. I just gave it a try, and it seems to work fine for me.
Good luck. Let us know how it goes.Thanks, I will go over my code.
I should not have said code as in VB, I should have said combo box wizard.Good luck. Let us know how it goes.
Just FYI though, I didn't use any code in my test. Cheers!
Oh, I see...I should not have said code as in VB, I should have said combo box wizard.
Hi. I downloaded your app. I see the combo in the datasheet. What's wrong with it?Tiny app, not very important, mostly a learning experience. Anybody interested in finding the problem?
Try a new record. Tell me what you get.Hi. I downloaded your app. I see the combo in the datasheet. What's wrong with it?
View attachment 86949
Looks like sequence. If I click on date sent it gives me a sort menu. I click again it gives me a date picker, then, the combo brings up list of names.Like this? I went to a new record on the main form and then selected an item from the combo. As you can see, it saved the new record I added to the subform. Not sure what steps you wanted me to try. I am not familiar with your app.
View attachment 86951
Ok, got it working thanks for your helpLooks like sequence. If I click on date sent it gives me a sort menu. I click again it gives me a date picker, then, the combo brings up list of names.
Hmm, not sure I understand. That doesn't happen for me. When I click on DateSent, I get a Date Picker. If I pick a date from it, the date gets stored in the field, and I don't see any "sort menu" anywhere showing up.Looks like sequence. If I click on date sent it gives me a sort menu. I click again it gives me a date picker, then, the combo brings up list of names.
Congratulations! You might consider posting either the solution or the working version, in case others could benefit from it in the future.Ok, got it working thanks for your help
Pilot Error! I have neuropathy in both hands. As I went to click in the date or combo the mouse would slide up where it doesn’t belong. However, I would not have discovered that without you telling me it worked for you. Thanks AgainCongratulations! You might consider posting either the solution or the working version, in case others could benefit from it in the future.
Hi. No worries. Good luck!Pilot Error! I have neuropathy in both hands. As I went to click in the date or combo the mouse would slide up where it doesn’t belong. However, I would not have discovered that without you telling me it worked for you. Thanks Again
I know the base is closed. Were you around when it was opened.Hi. No worries. Good luck!