<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1226" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=187285818-10092003><FONT face=Arial color=#0000ff size=2>To
replace a datasheet or continuous form, I use a DataGrid.</FONT></SPAN></DIV>
<DIV><SPAN class=187285818-10092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=187285818-10092003><FONT face=Arial color=#0000ff size=2>To
replace a single record Form, I create my own VB control with the controls I
want and set up properties within the VB control that let me interact with it in
terms of requerying, etc.</FONT></SPAN></DIV>
<DIV><SPAN class=187285818-10092003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=187285818-10092003>
<DIV align=left><FONT face=Arial size=2>Doris Manning</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Database Administrator</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Hargrove Inc.</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="http://www.hargroveinc.com/">www.hargroveinc.com</A></FONT></DIV></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
dba-vb-bounces@databaseadvisors.com
[mailto:dba-vb-bounces@databaseadvisors.com] <B>On Behalf Of
</B>paul.hartland@fsmail.net<BR><B>Sent:</B> Wednesday, September 10, 2003
6:24 AM<BR><B>To:</B> dba-vb<BR><B>Subject:</B> [dba-VB] SubForms in Visual
Basic 6<BR><BR></FONT></DIV>
<P>To all,</P>
<P>I have never had to use subforms in visual basic 6 as yet, but now I've
come to my very first project where I need one......</P>
<P>I have a parent form which contains the name & address etc of our
employees, then I need a sub form showing Sickdays and Holidays like below</P>
<P>Paul Hartland </P>
<P>999 Lets Be Avenue </P>
<P>0121 000 0000</P>
<P>01/01/03
03/01/03
3 Virus</P>
<P>04/05/03
04/05/03
1 Migrane</P>
<P> </P>
<P>and so on, I suppose I could use two grids, so I need to know what would be
the best way of doing this ?.......subform (which I need help on how to do
them, or grids which I may also need help with)</P>
<P>Paul </P>
<P> </P>
<P> </P>
<P><BR><BR></P>
<P><STRONG>I love deadlines, it's something about the whooshing sound they
make as they fly by.<BR></STRONG></P> </BLOCKQUOTE></BODY></HTML>