Combo Box = Query Field Name to search

[jlclark4]

I have a form with two controls in it and a query with 8 fields:



FrmDriver
cmbWeekDay
txtDate

QryDriverReport
Title (Text)
Monday (Yes/No)
Tuesday (Yes/No)
Wednesday (Yes/No)
Thursday (Yes/No)
Friday (Yes/No)
Saturday (Yes/No)
Sunday (Yes/No)

tblMain
Title

My goal is when I select a day of the week form the combo box (cmbWeekDay) and click sumbit, that the information marked as TRUE for that day of the week in the query appends to the bottom of tblMain. The appending I understand how to do. The part I am stuck on is linking the fact that the cmbWeekday contains "Tuesday" so lets look at Field "Tuesday" in the query and pull over all the TRUE values.

Any suggestions are welcome!


Thanks

[June7]

Multiple similar fields indicates non-normalized data, so does multiple yes/no fields. What you want is not easy (have dealt with this topic before) in an Access query object.

What do you mean by 'pull over' - you want record for each driver ID in tblMain where driver indicates Tuesday as Yes in tblDrivers?

Suggest VBA.

CurrentDb.Execute "INSERT INTO tblMain SELECT ID FROM tblDrivers WHERE " & cmbWeekDay & = " True"