HOW TO GET TABLE DATA IN VARIABLE

  • Thread starter Thread starter ezil
  • Start date Start date
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
 
On Thu, 5 Nov 2009 05:50:05 -0800, ezil

Check out the DLookup function.

-Tom.
Microsoft Access MVP
 
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
 
Back
Top