Retrieve data differently than dlookup

[vojaka]

Heips,

can you advice any new for me method to retrieve data from table to form. Now i am using dlookup() for every field, but i've read somewhere and do not rememeber where, that it's possible to use with the cycle. In this cases text box name and field name must be identical.
And also what do you think about "select from where" statement. I am interested in speed of retrieving information.
I have separate front end and back end using link with tables.

really appreciate any help. i am just beginner.

 

[namliam]

Just make a query to display the data you want from the table.
Then add the query as "recordsource" of the form and done.

This is called a bound form

 

[vojaka]

well that is the question what are the ways retrieve information in an unbound control. For bound it s quite simple in access.

Just make a query to display the data you want from the table.
Then add the query as "recordsource" of the form and done.

This is called a bound form

 

[gemma-the-husky]

if your form is BOUND, then you dont need to do anything, becasue the fields will be automatically populated

if you want to display other stuff that isnt in the forms recordsource then

a) if its not in any table, but is a calculation based on a existing field/control then
- do this calculation in the forms current event, and also in afterupdate events if
appropriate (push the value)
-or set some control source property to calculate automatically (pull the value)

b) if it is in a table then
- do a dlookup
- or open a recordset, and get the values from that (generally applicable to replace multiple dlookups to the same record)

 

[vojaka]

You mean to use ADO???

- or open a recordset, and get the values from that (generally applicable to replace multiple dlookups to the same record)

 

[gemma-the-husky]

well i use DAO, but i think you can use an ADO recordset, if you are used to the syntax

its just that opeing a recordset is more efficeint than, eg

dlookup("field1","whateverdomain")
dlookup("field2","whateverdomain")
dlookup("field3","whateverdomain")
dlookup("field4","whateverdomain")

 

[namliam]

well i use DAO, but i think you can use an ADO recordset, if you are used to the syntax

DAO is actually much prefered, as Access itself still uses DAO.
It has always used DAO, has attempted to move to ADO... making ADO the default set to work with, but.... gone back to DAO again.

So word to the wize, use DAO.

 

[vojaka]

thanks everyone. i will definitely use dao. Retrieving of information is pretty much fuster