Use combo box to run append query (1 Viewer)

Franciscobarrl

New member
Local time
Today, 20:25
Joined
Oct 9, 2019
Messages
3
Dear all
I am beginner in access and I have come up with a recent problem

I have a form with a combo box that have all the tables and querys of my database

And i want to run an union query from that

Like

Select *
From
(table from with name in combobox)

And then i wil transforme this into an append query

Can you help
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:25
Joined
May 7, 2009
Messages
19,169
combobox can only return 1 value.
if you need multiple items to be selected, try listbox.
 

Franciscobarrl

New member
Local time
Today, 20:25
Joined
Oct 9, 2019
Messages
3
I just want one value
I just want to to append a table with a name selected from the combo box

Thank you for the quick response
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:25
Joined
Oct 29, 2018
Messages
21,358
I just want one value
I just want to to append a table with a name selected from the combo box

Thank you for the quick response

Hi. Not sure if this is what you want.
Code:
CurrentDb.Execute "INSERT * INTO NewTable FROM " & Me.ComboboxName, dbFailOnError
Hope it helps...
 

Users who are viewing this thread

Top Bottom