How does access relate to queries

[Daniel Cooper]

How does access relate to queries? im currently working on
a small system which reads data from a form, loads it to a
query then updates a table. The problem im having is how
to get the data from the form to the query, if i knew how
access related to the query i.e. queryname.fieldname.text
= "blah" thats what i thought it would be but didnt work

any ideas?

 

[Michel Walsh]

Hi,


Within Access? the easiest way is to "bind" the form to the table (or the query used to show the
data). Under the table properties, it is the property RecordSource. Next, under the edit control
properties, assign the fields they should transfer the data, to and from, through the property
ControlSource. That's all. If you modify the data through the form, once you move to a new record
(or otherwise signify you are done with a record), Access will save the modifications, for you...
because Access knows you use a database, in the first place, so it does it very, very, simply, for
you. Note that if you use a wizard to create your form, the properties would be already set for
you, which is even simpler.


Hoping it may help,
Vanderghast, Access MVP