Unbound Form and subform

[Sara]

Hello,
I've had this problem for a while now, I have a form01 where the user enters
a customer id and the rest of the text boxes automatically populate with the
information of this cutomer this information comes from my Cutomers Table.

I created a separate form02 for data entry on my "Customer Inquiries" table,
now all the controls of my form02 are unbound, this form is not directly
bound to my Customer Inquiries table, instead I have a submit buton that
commits the entries to my table.

Form01 and form02 indenpendently work fine, however, I used the wizard to
add form02 as a subform of Form01 and form02 doesn't work if is embeded in
form01

I found information about linking the form and the subform but mainly for
data display, in this case in my main form I am retrieving data from
Customers table and in my subform I am entering data to Customer Inquiries
table

What am I forgetting?
If this is confusing i'll provide further details

 

[Roger Carlson]

Subforms work best with bound forms, however, they can be used unbound. You
don't say how the subform doesn't work. My guess is that you are
referencing controls on your subform form. But you need to reference them
differently when you embed your form as subform. That is, you have to
reference them *through* the main form.

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates how to reference
objects in subforms and subsubforms under a variety of circumstances.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Sara]

Thanks for the quick reply. I'm thinking that one of the problems is that my
main Form and Subform are not linked. Is it absolutely necesary for them to
be linked? I tried to link them but since all the textboxes that I have in my
Form and subform are unbound I get the message " Cannot a link between
unbound forms"

 

[Roger Carlson]

Subform were created to be used as bound forms. However, you still haven't
said what is not working now that works when they are used seperately.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Rick Brandt]

Thanks for the quick reply. I'm thinking that one of the problems is
that my main Form and Subform are not linked. Is it absolutely
necesary for them to be linked? I tried to link them but since all
the textboxes that I have in my Form and subform are unbound I get
the message " Cannot a link between unbound forms"

You can link a bound subform to an unbounr main form. You just can't use the
builder dialog to do it. You have to just enter the values manually. There
would be no reason to set these properties for an unbound subform as there would
be no effect anyway.