How Do I Add a Record to a LookUp Table via a Form - Microsoft Community

hello.

i trying make form button allow me add values in fields lookup table.i know how go table form, not form table.

my understand follows:

1. on frmaddlookup, have 3 fields: [product] [color] [shape]. these fields exist in tblproductlookup.

2. on each field on frmaddlookup, need set control source "product"/"color"/"shape". correct?

3. create button on frmaddlookup "save new record , close form"

is correct?

if so, how do "save new record" part in vba? not want "frmaddlookup" displayed continous form records listed tblproductlookup. want simple form 3 aforementioned fields. , button click take vlaues 3 fields , add them tblproductlookup

basically, yes, that's do. note form need tblproductlookup recordsource.

to avoid showing other records can set dataentry = yes, allows add new records. if want have button, code simply:

if me.dirty then

  me.dirty = false

end if

that save record.

Office / Access / Windows 10 / Office 365 Home