search in sql and put to access by same Id numbers?

[pinstripe]

hi,

i would like to make a search form in access, so i could look up in a sql express ... if data's id is equal with id in access then copy the data from sql into an empty fields in access?
can this be done and how?
thank you

 

[lespaul]

Try Forum702



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins