Combobox / dataSheet view

[Dick7Access]

Is it possible to get a combo box to work in datasheet view?

 

[theDBguy]

Of course. Why, what's happening with your combobox?

 

[missinglinq]

when you move into the Control 'down-arrow' will appear...for a selection to be made.

Linq ;0)>

 

[Dick7Access]

Of course. Why, what's happening with your combobox?

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

 

[theDBguy]

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

Hi. I just gave it a try, and it seems to work fine for me.

 

[Dick7Access]

Hi. I just gave it a try, and it seems to work fine for me.

Thanks, I will go over my code.

 

[theDBguy]

Thanks, I will go over my code.

Good luck. Let us know how it goes.

Just FYI though, I didn't use any code in my test. Cheers!

 

[Dick7Access]

Good luck. Let us know how it goes.

Just FYI though, I didn't use any code in my test. Cheers!

I should not have said code as in VB, I should have said combo box wizard.

 

[theDBguy]

I should not have said code as in VB, I should have said combo box wizard.

Oh, I see...

 

[Dick7Access]

Tiny app, not very important, mostly a learning experience. Anybody interested in finding the problem?

 

[theDBguy]

Tiny app, not very important, mostly a learning experience. Anybody interested in finding the problem?

Hi. I downloaded your app. I see the combo in the datasheet. What's wrong with it?

 

[Dick7Access]

Hi. I downloaded your app. I see the combo in the datasheet. What's wrong with it?

View attachment 86949

Try a new record. Tell me what you get.

 

[theDBguy]

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.

 

[Dick7Access]

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

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.

 

[Dick7Access]

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.

Ok, got it working thanks for your help

 

[theDBguy]

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.

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.

 

[theDBguy]

Ok, got it working thanks for your help

Congratulations! You might consider posting either the solution or the working version, in case others could benefit from it in the future.

 

[Dick7Access]

Congratulations! You might consider posting either the solution or the working version, in case others could benefit from it in the future.

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

 

[theDBguy]

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

Hi. No worries. Good luck!

 

[Dick7Access]

Hi. No worries. Good luck!

I know the base is closed. Were you around when it was opened.