Assigning Values to Fields from Query

[David_P]

Good day all,

I am familar with Access but haven't used it in several years and just
started using Access 2010. I am working on a databased based on an exteranl
database so I can't change the way the tables are set up. The tables combine
serval parts of information that I need to seperate into their own fields to
be able to edit.

I am working on a form to be able to look up the data from the external
tables and assign each part to a field. I have been able to seperate them
into their fields. Now I need to be able to filter each of these fields down
to find the proper entry in the table. Here is a shot of the form:

http://img826.imageshack.us/img826/3819/screenshot1f.jpg

I need to be able to filer the Job Code, Part Number, Task Code, Employee No.
and Status. I can use a query to filer these down to the Transaction I need
but don't know how to get it to assign the value to the Transaction ID field.

Thanks for your help.

 

[HiTechCoach]

From where does the Transaction ID come?

 

[David_P]

The Transaction ID comes from the Query that I use to filter down the fields. It is kind of like an Excel sheet where you apply a filter to each column and need to know what row all the data is on that meets the condition of each text box. The ID is the first column

http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=33769&stc=1&d=1284753219