Create a form to look up and enter data

[catbert]

I think I have been thinking about this for too long and can't see the answer so any help is gratefully received.

Background: We have a corporate SQL database recording all incoming complaints. I have been asked to write a basic access database to store information about audit work carried out on a number of these jobs daily. I have the odbc link up and running and can display these jobs, filtered if necessary, and I have a table which stores the unique ID from the database and any comments or work carried out.

Bit I am stuck on: The corporate database is huge, as you can imagine, so loading and searching this info takes forever. What I want to do is allow user to type in the unique number, and then have the form load the details linked from the corporate system. Then the user updates only those fields which store in the access database with only the unique ID from the corporate system

Where should I start? I'm still developing my access knowledge so be gentle with me.

Thanks

 

[MA04]

Hi,

I am also doing something similar, what i have done is created a search query which does the searches i want, bound it to a form and got labels to display the relevant details. I have also created a command button which carries out an append, which appends the loaded data on form view of the details i want to append from one table to another. I can also change data and then append. i have run a macro from a command button which carries out a reqery so i can keep appending. Hope that gives you an idea,

M-.

 

[catbert]

Great idea, gives me something to work on at least,thanks.

Fastest response ever as well!

All I have to do now is write it so that it makes sense to people who are resistant to modern technology ;o)

 

[MA04]

Let us know if you need any help,

M-.