If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
SSN Lookup
I am creating a database for work that tracks when a persons state
certification expires. I currently enter all data through a form, but when I am keying in a certification that happens to be a renewal, of course I get the duplicate error message. Is there a way that as soon as I enter the social, the form checks the table, if the social exist it would display that information so i can update the date, and if it doesnt exist, create a new entry? |
#2
|
|||
|
|||
SSN Lookup
Put a ComboBox on your form that "Looks up a record" in your RecordSet. It
will be unbound and have code in the AfterUpdate event that can be modified slightly to do what you want. You will leave your current SSN control alone other than locking it and fill it in from the ComboBox AfterUpdate event. Rosco wrote: I am creating a database for work that tracks when a persons state certification expires. I currently enter all data through a form, but when I am keying in a certification that happens to be a renewal, of course I get the duplicate error message. Is there a way that as soon as I enter the social, the form checks the table, if the social exist it would display that information so i can update the date, and if it doesnt exist, create a new entry? -- HTH - RuralGuy (RG for short) acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200707/1 |
Thread Tools | |
Display Modes | |
|
|