Button to import data

A

Andi

Is it possible to add a button on a form that would:
1-Locate a record in another table using one designated field
2-Import that record as a new record in the current table
3-Allow modification of the new record in the current table

If so, can you tell me exactly how?

Many thanks!
 
D

Daniel

1- look at the dlookup function it should permit you to retrieve/identify a
reocrd based on a criteria.
2- A couple of methods can do this:
You could loop through each field and copy them one by one (not the most
efficient)
SQL statement using the INSERT INTO statement (google it for more info)
Allen Browne has some info on this chekc it out at
http://allenbrowne.com/ser-57.html
3- This is controlled by your form, if your user has permission to perform
edits then they should be capable of editing the record no problem.

Daniel P
 
Top