Need to put info from form "lookup" fields into main table

[ImJay]

I have a request to create a series of forms in Access that provide succeeding bits of information back to a main table. Each row of the main table describes a preventive maintenance activity from request to scheduling.

The first form (InputForm) would include three lookup fields (dept, ext, pager) from tblNamesSite based on field "name". The content of the three linked fields must be included in the MainTable to be available thereafter.

The second form (ScopeForm) would look up "WorkOrderNumber" based on "PreventiveMaintIDNumber" or "Work RequestNumber" from an Oracle database. These three fields must also be populated in the table and called up on the approval forms. And so on, and so on.....

I researched this problem and found only one possible solution (aside from the obvious, it should be on SQL server) and found the update or edit/update function. Is this a viable solution? What is the proper syntax? Should I initiate a batch event or trigger from the form?

Thanks,

Imjay

 

[Golom]

If you are creating Access forms then forum702 - Microsoft: Access Forms is probably the place to be. This is VB6 and VB Forms are not the same as Access Forms.