use form name in underlying query?

[pbuethe]

I have different versions of a form. The version of the form used depends on the current record. Each record has a field FormID and the form names correspond to the form ID's, e.g. if the FormID is 11267, that record uses frm11267. I want to know if in the underlying query of the form(s), there is a way to have a variable criterion for FormID, which gets the name of the form (or the part equivalent to the FormID), so that if I open the form directly, it will contain only the applicable records. I want to use the same query for every version of the form since there may potentially be many versions in the future. Is this possible? If there is some code involved that is OK too.

 

[quest4]

Why the use of many forms? Select Case should be able to reduce your number of forms to one maybe two at the outside. In my last dbase, I should have had at least fifteen main forms with subForms, I have one. It is a large Select Case statement in the forms OnCurrent event that controls what everything is doing in appearance and anything else. Oh, and because it is one form, I have 0 queries. Think about it. hth.