Pop-up form Spawned by Main (How do you connect data?)

[BitCounter]

I have a main form..to save the operator from having to tab past fields that might not be entered on every record, I would instead like to put something like a checkbox that they would select to indicate that a particular student has attended workshops. It would look like this:<br>

<br>

Attended workshops? [ ]<br>

<br>

Once selected, my program would spawn a new form which would only collect the information regarding workshop attendance. My question: How do I relate the data collected from the workshop form to the record that was being edited when the operator selected Attended workshops. I am using an ADO data control to connect to an Access 97 database. All of the fields from the main form and the workshop form are on the same table. Any suggestions would be very much appreciated! Specifically, code snippets would be heaven!<br>

<br>

 

[DougP]

Well have a field in your table that is the check box its a Yes/No data type instead of Number or Text.<br>
(to make a check box on your form look in the &quot;ToolBar&quot; there is a &quot;Check box&quot; and a &quot;Option button&quot; the check box is square) then if someone checks the box your query will look to see if the Checkbox field is True (checked) or False (not checked).<br>
<br>
<p> DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br>