Insert results of query into textbox fields on a form

  • Thread starter dan2bhm via AccessMonster.com
  • Start date
D

dan2bhm via AccessMonster.com

I've fumbled around with this for a while, but I can't figure out the best
way to accomplish this.

I have a query that will give me a list of Names for a particular company. I
have a form setup with 10 textboxes. What I'd like to do is to set the
default value for those Name Textboxes to the results of the query. Some
queries result in 10 queries, while some result in 3. If I do a lookup in
the default value, it will always return the first item in the query results.

It seems like this should be a FOR EACH statement, but I still can't figure
this out

Does anyone have any ideas???
 
S

strive4peace

Instead of using 10 textboxes, why not use a listbox and
make the query its recordsource?


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 
D

dan2bhm via AccessMonster.com

strive4peace said:
Instead of using 10 textboxes, why not use a listbox and
make the query its recordsource?

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
Click to expand...


What a FANTASTIC and simple idea. Good thinking - thanks a million.
I've fumbled around with this for a while, but I can't figure out the best
way to accomplish this.
Click to expand...
[quoted text clipped - 9 lines]
Does anyone have any ideas???
Click to expand...
Click to expand...
 
S

strive4peace

you're welcome, Dan ;) happy to help

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
strive4peace said:
Instead of using 10 textboxes, why not use a listbox and
make the query its recordsource?

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
Click to expand...



What a FANTASTIC and simple idea. Good thinking - thanks a million.
I've fumbled around with this for a while, but I can't figure out the best
way to accomplish this.
Click to expand...

[quoted text clipped - 9 lines]
Does anyone have any ideas???
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Results of a query into a textbox 2
Show query results in form 5
Load Query Results Into Form 9
How to display query results in text boxes? 1
Populate form from text box entry 2
Insert a query result into a form or text box 5
If statements blanks form when no results on query 4
Show query results on a form 6

Top