Text box and tables

[Spelthorne1]

Ive looked and looked for any other postings on this subject but none have answered my problem.

The form 'DataCapture' has a record source of 'WC16Feb' and numerous text boxes.
I also have another table 'Work_Done_TodayQR' that i want the form to look at and show the values in some text boxes.

I have tried within the code (an onclick event) to change the recordsource and controlsource of the txtboxes but to no avail.

i.e
txtSum.ControlSource = "Work_Done_TodayQR"

Another question:
Is it possible to run a select query and have the values returned show in a textbox on a form?

 

[Parker]

Ive looked and looked for any other postings on this subject but none have answered my problem.

The form 'DataCapture' has a record source of 'WC16Feb' and numerous text boxes.
I also have another table 'Work_Done_TodayQR' that i want the form to look at and show the values in some text boxes.

Run a select query behind the text control in question.

Another question:

See above

 

[Spelthorne1]

Run a select query behind the text control in question.



See above

How? - im very new to this vba and access stuff so dont know how i would do that

 

[Parker]

OK simple way

Use a list box and use the "Row source" property to build the query you need.

or

Use the query builder to get the imformation you want and use the result of that query as the record source of your text box

Both have pro's and con's and If you study the Northwind db example included with access then you will discover other ways to achieve your required end result.

The question that you are asking is very basic access stuff and the answer you need is written a thousand times in Access help and included examples.

Often we just don't know how to ask "help" in the right way! Try typing "display query result" in the help search screen.......... it will come up with a few things that will then give you ideas for more searches.
Better to learn this way than have some one do it for you.

A more in depth answer here on this subject will just result in repeating information that is already on your desktop.

 

[Spelthorne1]

OK simple way

Use a list box and use the "Row source" property to build the query you need.

Often we just don't know how to ask "help" in the right way! Try typing "display query result" in the help search screen.......... it will come up with a few things that will then give you ideas for more searches.
Better to learn this way than have some one do it for you.

A more in depth answer here on this subject will just result in repeating information that is already on your desktop.

Thanks Parker!
Sometimes you need a help full prod in the right direction - Its better to learn than being spoon fed!