textboxes

[lavina]

Hi,

Can i use the same text box to display the result from
query as well as send the information displayed in the
text box to a field in a table? If so, how?

Please help.

Thank you.

 

[Michel Walsh]

Hi,


Yes, that is exactly what does Access do for you when you create a bound form... just select a
query, rather than a table, when it is time to create the form.


The values displayed are pumped from the query, if you edit one of them, and save the record
(moving to another record, or closing the form), the form will try to save the modification to the
tables.

You have nothing special to do. Access knows the general purpose of using a form and do all the
programmation job for you, in that case.



Hoping it may help,
Vanderghast, Access MVP