Prev: filter combo box in subform withe a combo box in main form.
Next: dropdown to filter records
From: Jim on 18 Jan 2010 10:00
I have a text box that goes to a specific record on a form after update. I
want the user to be able to add new records so that if the value entered in
the text box isn't found on the form, it goes to a new record and sets the
value of the "matching" field to whatever was entered in the text box.

txtMos = Mos

If the Mos (mm/dd) isn't in the table, I want them to be able to add it.

Make sense?

Thanks!
Jim
From: ruralguy via AccessMonster.com on 18 Jan 2010 10:37
Have you tried a ComboBox and using the NotInList event?

Jim wrote:
>I have a text box that goes to a specific record on a form after update. I
>want the user to be able to add new records so that if the value entered in
>the text box isn't found on the form, it goes to a new record and sets the
>value of the "matching" field to whatever was entered in the text box.
>
>txtMos = Mos
>
>If the Mos (mm/dd) isn't in the table, I want them to be able to add it.
>
>Make sense?
>
>Thanks!
>Jim

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1

 | 
Pages: 1
Prev: filter combo box in subform withe a combo box in main form.
Next: dropdown to filter records