Writing to a Query

[rpeeler]

I do not know if this is even possible but here it goes.

I have a table with 2 fields Builder Name and

On a form I am giving the user the option to choose a builder's name from a drop down list and select a status for that builder from a toggle switch.

Once that is complete I then want to have a print preview toggle button that is running off a query, that would print the filtered data they have selected.

I have the query, but I do not know how to write to it.

Any ideas

[PEB]

Hi,

Hope that helps:

Set mydb = CurrentDb()
Set Myquery = mydb.CreateQuer yDef("WriteQuer y", "Select * FROM Yourtable;")

:)

[rpeeler]

thanks, it works great