Subform

[smiller]

I have a part that is specified by two categories--type and spec #. I have multiple of each part that I need to chart the in and outs of. I was trying to create a form that would give the part and then have a subform in it with which I could see past transactions along with insert new data. This way if I go to a certain part, I can see every time the part was taken out or returned. Right now when I go into the form, the subform appears blank each time. If I go into the subform directly, then all my information is posted. Any suggestions on how to have the subform data appear within the form for each part? Thanks

 

[smiller]

if you are referring to the link child and master fields in the properties of the subform then yes I did. I currently have the 2 forms linked with 3 categories. If you are talking about anything else then no I have not linked them.

 

[smiller]

ok i put in a relationship too just to make sure that wasn't it. I realized now that if I put information into the subform, it sometimes reappears and sometimes not. I have the form and subform linked by type, spec #, and description. All parts have both a type and spec #. If the description field is left blank, then the subform does not show past records. If all 3 categories do have information stored in them, then the information reappears. Not everything will have descriptions and I must keep this field linked because there are some parts with the same type and spec # but a different description.