What is it i am doing wrong??

[bunji]

I am trying to create a form that has an unbound text box which row source is a field in a table. I have created a subform that gets the records from another table.

Both tables are linked in a one to many relationship. When a user selects a record in the cmbo box i want the table to show only those records which are related.

This obviously didnt happen. So i changed the subform instead of a table as its source but a query, then in the criteria of a query just set it to look at the cmbo on the form. After the cmbo was updated i got the subform to requery.

This worked fine, but i was unable to make any changes or updates but with no particular error.


When inserting a subform using the wizard i do remember coming across a section of a wizard that asks me if i would like to tie in the subform with something on the form. However this part of the wizard just doesnt show. Maybe i was using a different version of access for this wizard?? i am currently using Access XP.

Am i really going MAD!!?

 

[Pat Hartman]

Is the main form bound? If it is, you need to set the master/child links properties of the subform control.

 

[bunji]

Hi Pat Thanks for the reply but no its just a new form started in design view then added the cmbo box then the subform.

 

[bunji]

Well from what Pat i thought that maybe i should try binding the form. Once i changed the master/child links it worked. So Thank you Pat