Adding two fields to a table

[HowardChr via AccessMonster.com]

I current have the following code which works perfectly now:

CurrentDb.Execute "INSERT INTO [Input] ([Loc_Desc]) VALUES (""" & Me.
List12 & """)", dbFailOnError

I would however like to add another field's information named (Lnd_Desc) as
well in the same row of table (Input). What should my syntax look like for
that one.

 

[Corey-g via AccessMonster.com]

INSERT INTO [Input] ([Loc_Desc], [Other Column]) VALUES
(""" & Me.List12 & """, """ & Me.other value & """)", dbFailOnError

Shouyld be close - depending on the datatype (for the quotes required)

HTH

Corey

I current have the following code which works perfectly now:

CurrentDb.Execute "INSERT INTO [Input] ([Loc_Desc]) VALUES (""" & Me.
List12 & """)", dbFailOnError

I would however like to add another field's information named (Lnd_Desc) as
well in the same row of table (Input). What should my syntax look like for
that one.

 

[HowardChr via AccessMonster.com]

Got it... that worked, THANKS!

INSERT INTO [Input] ([Loc_Desc], [Other Column]) VALUES
(""" & Me.List12 & """, """ & Me.other value & """)", dbFailOnError

Shouyld be close - depending on the datatype (for the quotes required)

HTH

Corey

I current have the following code which works perfectly now:

[quoted text clipped - 4 lines]

well in the same row of table (Input). What should my syntax look like for
that one.