SQL, Recordsets, Forms, Subforms...

[buzzboychicago]

Hi,

I am creating some dynamic forms and need to be able to query off of the data that is in the form including unbound fields.

For example...

I have a subform with a list of records that I want to export upon the click of a command button, but I only want to export the ones that have checks in the unbound checkbox next to that record.

Also, I need to know a way to have another checkbox that I check which causes all the records in the subform to be checked, and then when unchecked all the records in the subform become uncheck. basically a selectall/unselect all checkbox or toggle button at the top of the form or on the subform header.

I am assuming the first paragraph requires using DAO or ADO recordsets which I don't really have a grasp of yet. Can someone give me the basics (what you have to declare) etc or direct me to a good FAQ?

THanks!!

 

[buzzboychicago]

Oh...another example...

when I am going to press the command button...

I need to run a count of the checked boxes in the continuous subform. (So if it is 0 I can message the user)

Any ideas if say my control name was "sendemailchkbox

 

[PHV]

Be aware that in the Detail section of a continuous subform an unbound control has the SAME value for ALL the records...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[talbotlives]

I was working on a very similar problem to this last week and have a "sloppy" fix, and am looking for anyone with better solutions. I have a continous form of search results, and then the user has to be able to select a particular result to view in detail. Right now, they see each result's ID number in the detail section, reinput that number in a textbox in the footer which opens the detail form to that record. Any better methods/suggestions? Thanks