button

  • Thread starter Thread starter clueless2003
  • Start date Start date
C

clueless2003

Guest
How easy might it be to input a button in my form that the user will click on after inputting data into the combo box? Please don't ask me why I want to do this, the fact is I mentioned this as a possibility to my project manager, he loves it, and wants to see it!

thanks in advance
 
What exactly is the button supposed to do?
 
Basically, the button is to serve the same function as the Enter key. When the user inputs the data in the combo box and presses the button, the other fields in the form are populated (based on the combo box). Please don't ask why we need this? :p
 
Clueless, don't spread your posts around if they are all linked - use the same topic to ask a few questions as creating multiple topics does not allow others to see the solutions people have already suggested. Related topics

combo box #2

combo box #1
 
It has to be asked .. Why?

Why not just do an OnEnter event or something similar? Do you need it so that the user can validate the information before submitting the data? Remember a when talking to your Project Manager ... A closed mouth gathers no feet.:)
 
Demona,

I would have no problem taking alternatives to the PM if I knew exactly what they were!

Perhaps you can help me. The user inputs a six-digit account # in the combo box. This is where I would have the user click the bloody button. I think a better alternative to the button or the Enter button would be if I could get the fields dependent on the combo box to populate immediately after the sixth digit is entered. I like this idea alot, but I'm not entirely sure how to go about it.

I would appreciate any assistance.
 
Rich,

I'm not familiar with this. Could you be more specific please? Thanks.
 
I'm assuming that you just want the infomation from the combo box viewed on the form and that you aren't needing to save it to any table.... I am going to post a db, I hope you can open it up.

Basically, you have the combo box with all the fields you want to view, you have the column count under properties for the combo box set to the number of fields you want to use, and under column widths, you will put something like 0;2;0;0 so that the only column that will show in the combo box is the one that you want....

Then you have some UNBOUND textboxes on the form. This is where your information will show. Look at the AfterUpdate Event on the Events tab on the combo box to see how to populate the unbound textboxes. For each unbound field, change the column number to the appropriate one. Hope that helps....
 

Attachments

Okay...so the After Event Procedure should be a variation of this:

Me.txtName = Forms!FormName!ComboBoxHeading.column(2)

Correct?
 
Yes, with me.txtname being the name of the unbound textboxes and the column corresponding the the position of the field in the combo box query grid. I start with column 2 because in my example, the autoID is column(0), and the Product Number or whatever is column(1).

So you would end up with something like this on the AfterUpdate Event (Depending on how many fields need to show up):

Me.NameUnbound1 = Forms!FormName!ComboBoxHeading.column(2)
Me.NameUnbound2= Forms!FormName!ComboBoxHeading.column(3)
Me.NameUnbound3 = Forms!FormName!ComboBoxHeading.column(4)

Unless any one out there has any better ideas......
 
Thanks for the further clarification, Doss.

What, if anything, would I put in the After Update Event in the combo box field? I apologize if this is brutally mundane and clear to the rest of you, but I'm trying to work on a few tasks in addition to this db, so I haven't had the opportunity to do a whole lot of trial and error!

I'm sure I'll have a few more questions, but I really do appreciate all of the help this forum has given me to this point.
 
Me.NameUnbound1 = Forms!FormName!ComboBoxHeading.column(2)
Me.NameUnbound2= Forms!FormName!ComboBoxHeading.column(3)
Me.NameUnbound3 = Forms!FormName!ComboBoxHeading.column(4)

This is what is going in the AfterUpdate of the combo box field.
 
Ooooooh.... I'm sorry, I'm an assface.

So, this presumably should clear up the problem I've been having with inputting values in the combo box and having the outputs have nothing to do with the inputs. That's been....kind of an issue!

I'll try this and get back to you. Thanks.
 
No problem.

Hopefully that works out for you. Much better than doing the "button" thing.
 
The combo box is working much, much better now. However, I'm still intrigued by the idea I mentioned earlier in this thread. The input to the combo box must be no more or less than 6 digits. Is it possible for Access to automatically populate the fields dependent on the combo box immediately after the user finishes keying in that 6th digit?
 
Take a look at this sample that I threw together. The idea behind combos is to NOT have to type all the characters but to only type as many as you need to get to the item you want and then tab into the next field.

Combos don't support the autotab property so you can't make them automatically tab when they are full as you can with text boxes.
 

Attachments

Thanks Pat.

I'll have to keep that in mind so I don't cause more work for myself......
 

Users who are viewing this thread

Back
Top Bottom