fill text box with query value

M

Mark56

I'd like to fill a text box with a particular value from a query, so that
when the form opens I can display, say the 2nd value in the query. I'm
actually trying to display the first 5 values from the query, but figured I
could use five separate text boxes, one showing the first value, another
showing the second value, etc.
 
T

Tom van Stiphout

On Tue, 5 May 2009 01:39:01 -0700, Mark56

Perhaps better to use a subform, which is designed to do these things.
Then set your query to be a Top 5 query.

-Tom.
Microsoft Access MVP
 

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

Combo Box Lookup Value 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Basing one combo box on a query result and auto fill a second fiel 11
Fill in form using query 2
text box format 11
auto populate text box based on combo box value 1
Problem with filling form using query? 2
Currenct issue with a text box 1

Top