This should be a simple task, but I have yet to figure this out.
In a form, you the FIND command or the Find button will allow a user to enter the criteria for a specific field and the form will display, or jump, to that record if they are using the primary key field.
But how do you allow a user to enter the criteria to jump to a specific record in a from with a compound key. I have tried and searched till I am really annoyed, or exhausted (lol). The docmd.findrecord works with only 1 field. Seek is DAO (and still doesn't quite work appropriately), and the
docmd.gotorecord requires that you know the record number or an offset.
There must be a simple way to make a specific record active in a form with a compound key because this is a common requirement in most applications. Hopefully someone can guide this lost soul becuase I simply cannot find the appropriate command or technique to make this happen. We are currently using Access 2000, but will be upgrading to Access 2003 very shortly, so I need to use a technique supported with the new DB (not Jet or DAO is what I am told).
Thank you in advance for anyone with the guiding light.
In a form, you the FIND command or the Find button will allow a user to enter the criteria for a specific field and the form will display, or jump, to that record if they are using the primary key field.
But how do you allow a user to enter the criteria to jump to a specific record in a from with a compound key. I have tried and searched till I am really annoyed, or exhausted (lol). The docmd.findrecord works with only 1 field. Seek is DAO (and still doesn't quite work appropriately), and the
docmd.gotorecord requires that you know the record number or an offset.
There must be a simple way to make a specific record active in a form with a compound key because this is a common requirement in most applications. Hopefully someone can guide this lost soul becuase I simply cannot find the appropriate command or technique to make this happen. We are currently using Access 2000, but will be upgrading to Access 2003 very shortly, so I need to use a technique supported with the new DB (not Jet or DAO is what I am told).
Thank you in advance for anyone with the guiding light.
