Auto Add new Value through a combo-box

[raffi]

hello i created a data entry form where it has a PO# combo-box the reason i turned it into a combo box cuz i have a table where i need to store all the PO's so later i can turn it into a main form with the data entry other info as sub form, ok i need to see if its possible to auto add a new value trough a combo-box into its table, or if i can create a form and a load event maybe where it will add the value and save and close through the combo-box



now i know there's the list item edit form in the property but i need to check if theres any shortcut way quickly adding to its table while im doing data entry.

thank you

[June7]

Explore the combobox NotInList event.

[raffi]

alright i created a form out of the PO table and i set a text field and a button in the data entry form within the button i added the event,

SetTempVar

name : VarAddFromTxtField
Expression : [ the txt field name here ]

open form

form name : [ Form of PO table ]

data mode : add

closewindow

and within the PO form i created a load event

setproperty

control name : the PO Number Field here

property : value

value : =[tempvars]![VarAddFromTxtField]

and now whatever number i add in the in the txt box and click on the button it auto adds that number into the PO table, lol and theres another combobox in the same form where i can choose the newly created PO number....

lol its not exactly how i imagined would be like .. well its just slightly tiny bit faster then switching forms

and once again thanks! =]

[June7]

That isn't using the NotInList event of combobox.

I don't use macros, only VBA.

[raffi]

well i got a lot of learning to do in vba the only reason why i ended up using temp var is cuz my vba skills are low o well must learrnnnn but thx anyway for pointing me to the right direction

and i discovered theres a downside, if i click the button twice it will add the same PO number twice =l lol got to be careful now heh.

[June7]

Code could check if the PO is already in the table. I think macro could use a DLookup for that along with an If Then.