HOW TO GET TABLE DATA IN VARIABLE

E

ezil

The following codes are working perfectly

a=forms!forms1.field1
forms!forms1.field1=a

like this any code is there for getting values directly from table ?

i tried
a= tables!table1.field1
but it is not working
 
T

Tom van Stiphout

On Thu, 5 Nov 2009 05:50:05 -0800, ezil

Check out the DLookup function.

-Tom.
Microsoft Access MVP
 
G

Gina Whipp

ezil,

I gather by the limited information provided the table is not part of the
RecordSource of the form? Look up Append or Update queries in help... again
from your limited description I can't tell if you want to Append the data or
Update preexisting data.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 

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

how to get table values into variable 3
validation rule (for a record in a table) with dlookup 7
add variable table name to query results 4
if table1.field1 is empty, table2.field1, table1.field1 in form 1
lookup question 1
Remove commas w/in quotes 4
Add column with data to an existing table 8
Calculating a field based on other fields in a form... 1

Top