Button to import data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

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

Separate Form 0
How to export table from outlook into ms access table? 0
DMax on existing record to increment serialized # fails 1
Filling in fields to a partially complete record in a table using a form 0
trouble using button to open new form to add new record 1
Adding data from one form to another 5
Access Automatically Send a notification email once a record is added 0
'Add Record' button on a form 6

Back
Top