Query and Combo box in Form

[Guest]

Hello all,

I am really in trouble with creating combo box on Form!

I have a Query including Username and Mins

Now, I do want to create a Form which containing 2 fields from Query.

- Username is Combobox
- Mins is Textbox

When I choose one of the record from Username Combobox, the Mins Textbox is
automatically showing the appropriate value for that username.

What should I do to get the right results?

Note: I want at 1st, the Combobox and Textbox are blanks. I did try some
solutions from members who tried to help me. But they didnt work!

Looking forward to hearing from you all!

 

[kingston via AccessMonster.com]

Your combobox should not be linked to a control source (i.e. it should be
unbound), but it should contain a row source string that points to the user
names. Use the combobox's AfterUpdate event to populate the textbox. Do you
have a query that returns results for the selected user or do you plan on
finding the right value in code? What is the function of the text box? Is
it bound or unbound? In other words, is the text box used to record data or
is it just for display?

 

[Guest]

Thanks for your recommendation.

I got the solution! I always looked for the Control Source . NOw I know I
shouldn't Thanks again!