I might be going about this totally the wrong way. What I am trying to do is
FORM – NCR main entry screen This is the main styarting point.
Tabs: NCR header – is where the starting info is placed when new file opened.
Desc and Inst – is where the different types of problems go. Different files can have many different types of problems
Sort information – This is where I am having a problem. I have already made a small subform to get the tag numbers from the 1st tab: (on a side note this might be wrong since I can open this and then make changfes to the tag numbers but this does not update…. I think I need to the something like Me.dirty but I can not remember right off.)
What I am trying to do is have a table where the tag number is taken from the subform on the sorting page and the desc column is limited to only the desc found on the 2nd tab so in the end I have the following in the Sorting Info table
Example of data wanted in table
NCR Tag Description Rejects found
2421 1 Parts not Flat 12
2421 1 Nicks and dings 4
2421 2 Parts not Flat 14
2422 1 Part Too think 125
2421 2 Nicks and dings 7
2421 2 Burr on ID 11
NCR should come from the opened file
Tag should come from the subform on the tab
Desc shoud be limited to the list in the 2nd tab : I made this a query. but when I try to make the table the inof is not shown.
I have attached the file so this will make more sence,
