How do I make a bound form.

[tjcinnamon]

I have a form that has a subform in it. I want the key field in the form to dictate what fields show up on the subform. When I try to set the Link child and master fields, I get a 'can't build a link between unbound forms'. How do I make this subform bound to the form????

Thanks, JOe

 

[MStCyr]

What are the key fields for both your master and sub tables? Typically your master table would be an Autonumber and your subtable would be numeric, long integer.

 

[tjcinnamon]

My master for the form is a Van # (primary key), in the subform I want to show all the maintanance done for that van. For some reason I keep getting that error message when I try to link the child and master fields.

 

[RV]

You need a master table and a child table and set up a relationship between the two of them in the Relationships window.

If VanID (don't use special signs such as #) is your primary key in your main table, you should have a similar column in your child table as the foreign key.

And both your main form and subform should be based on a table / query.

RV