kingsgambit
Registered User.
- Local time
- Today, 20:44
- Joined
- May 27, 2001
- Messages
- 134
I have build a search form for users, they can type in a clients number or part of in a text box, the results are shown in alistbox, then the user clicks on which ever record they want and a forms opens with that record.
However each record does not have a unique ID so I put a autonumber field in so each record was unique, but my filter will not work
DoCmd.OpenForm "MASTER", acNormal, "", "[Record No]=[Forms]![search]![search]", acEdit, acNormal
[Forms![MASTER]![Record No] = Forms!search![search]
If I get the user to input a ID number for each new record it works.
I want to automatically produce an ID number instead.
Any suggestions on how to make each record unique
However each record does not have a unique ID so I put a autonumber field in so each record was unique, but my filter will not work
DoCmd.OpenForm "MASTER", acNormal, "", "[Record No]=[Forms]![search]![search]", acEdit, acNormal
[Forms![MASTER]![Record No] = Forms!search![search]
If I get the user to input a ID number for each new record it works.
I want to automatically produce an ID number instead.
Any suggestions on how to make each record unique
