update table - If not in list

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

Hi.

I have a combobox containing all the material available. the user could
choose from a list rather than having to type all the stuff.
the combo box's data source is coming from a query based on a tblMaterial
just containing one field which is the pk as well
now if a user needs a material which is not in the list he has to type it.

how can I somehow add this new material to the already existing tblMaterial
???

I presume something if notInList .... but don't know how to start ... so any
help and code ideas most welcome

Thanks,
Gina
 
Thanks
found a way

SQL = "INSERT INTO tblMaterial VALUES ( '" & NewData & "' )"
DoCmd.RunSQL (SQL)
Material.Requery

:)
 
Back
Top