Access forms and unbound error

[sidalam]

Working with Microsoft Access
I have created a form in Design view called Customers
and created another form that is called "Find Customer" also in Design view

"Find Customer" includes subform Customer
I want to link a text field in the main form to the subform but I receive an error dialogue box titled "Subform Field Linker"

Can't build a link between unbound forms [ok]

 

[MajP]

If you are using the wizard it will give you this error, if you do it manually it will not. I wish MS would fix this issue because it suggests that subforms are far more limited than they really are. There is no reason you can not do what you want. You can also link multiple continous subforms this way, but the wizard will give you the same error.

Put your subform on the main form, but do not use the wizard or cancel out of the wizard once adding the sourceobject. Now simply in the subform control

link Master Fields: [yourControlOnMainFormName]
link Child Fields: [theFieldRelatedToTheValueOfTheControl]

ex Main form has a combo box callled "cmboCustomers" that returns a customerID. The subform has a field called "customerID"

link Master Fields: [cmboCustomers]
link Child Fields: [cusomterID]

 

[MajP]

The other reason that this bothers me about the Access Wizard is that this concept is the easiest way to build a search form, but the wizard will not let you do it. There is no code required to do this technique.

 

[TheAceMan1]

How are ya sidalam . . .

You really don't need the [blue]Find Customer[/blue] form. An [blue]unbound[/blue] combobox in form [blue]Customers[/blue] would do the trick. Using the [blue]combobox wizard[/blue], just select the option [blue]I want the combo box to look up the values in a table or query.[/blue] Complete the wizard.

Perform your testing!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[MajP]

http://www.4shared.com/file/97759751/2cc085c4/SubForms.html

This demo shows a few of the things that the Access wizard suggests you can not do.

1)Unbound Main form with continous subform, linked to single record view subform, linked to another continous subform.
2)Unbound main form with single view form linked to a combo box. (What I believe you are trying)