Issue with filtering a subdatasheet then adding more data to the table...

[Fish218]

I have a form with subdatasheets. In one subdatasheet [subLT], I have the field [TagNumber], which is a field in tblTags. I have already entered the tag number into tblTags with information on the date the tag was issued, who it was issued to, etc. When I get the tag back, I want to be able to enter the tag number in [subLT] and have the other subdatasheet [subTags], which is just tblTags, bring up the appropriate record with the tag number, then automatically enter information such as the date the tag was returned (which would be based on a text box on the form).

The issue I'm having is not being familiar with filtering in general, plus not being familiar with filtering a subdatasheet based on a field in another subdatasheet, then automatically entering information to complete the "Tag" record. Any information or examples would be greatly appreciated. Thanks.

[June7]

You have two subdatasheets bound to tblTags? Why? Do you want to provide project for analysis?

[Fish218]

No, I have two subdatasheets ([subTags] and [subFish])) bound to two seperate tables ([tblTags] and [tblFish]). I just use the field "Tag Number" from subTag in subFish. It's how the flow of the data entry works. What I need is an afterupdate procedure for TagNumber in subFish. Once the tag number is put into the field, the missing values for the other fields in subTags will populate, such as the date the tag was returned which is just a text box filled in previously. Should be simple, but I am not familiar with filtering.

[June7]

Is this what you are trying to do: http://www.fmsinc.com/MicrosoftAcces...edSubforms.asp

[Fish218]

Yes similar to that. I tried what was suggested, but when it filters, the data already in the table disappears. I'm not sure why, it should just filter the existing table by Tag Number, keeping the original data in the table, right?

Perhaps theres and easier way to do what I'm trying to do. I'm trying to add data to an existing subform by filtering a subform. Am I missing something?

[June7]

I don't follow "add data to an existing subform by filtering a subform". Do you want to provide project for analysis?

[Fish218]

I would provide the project, but not sure how, plus I have sensitive data already in there.

[June7]

Make copy, remove confidential data (names, addresses, phones, ssns, whatever), run compact & repair, zip if large, attach to post. Attachment Manager is below the Advanced post editor.