query to form

[eddcole]

hi all

I wonder if this is possible

I have a query that returns multiple results of check boxes relating to week numbers that a task is required.
This is invoked by inputting the week number in a form and its frequency.

I then have 52 check boxes on my form relating to the week numbers. can I get the results from the query to update the boxes on the form so that the data can be recorded in a table. I need to then be able to create a query on the table to return other results. I can do that bit but cannot get the data from the query to the form/table

Cheers guys

 

[boerbende]

Something like:

Dim rs as dao.recordset
dim SQLstr as string

SQLstr = " select week1, week2, week3 .... from your table"
Set rs = CurrentDb.OpenRecordset(SQLstr)
me.checkboxweek1 = rs.Fields("week1")
me.checkboxweek2 = rs.Fields("week2")
rs.close

etc

 

[eddcole]

CHEERS for that

 

[sneuberg]

Why don't you just make the table the record source of the form and make the fields the control sources for the check boxes?