cant build a link between unbound forms

K

kknowles

Hi, my question is very similar to that of [Thelee - 10-28-2005 14:49],
however it didnt say how the problem was solved.

I have a form: in the form is a combo box and a subform. I want to select an
item number in my combo box, and bring up all of the info for that given item
number in my subform.

When attempting to link master/child fields in my subform properties, i get
the error message "cant build a link between unbound forms".

Any suggestions would be appreciated!
Thanks!
 
B

Bill Edwards

If the subform is a bound form then you can link it to the main unbound
form;

Link Child = the name of the field (ItemNumber) in the subform
Link Master = the name of the combo box (eg. cboItemNumber)

If the subform is an unbound form as well, then you will have to change the
recordsource of the subform when the user makes a selection from the combo
box. In the after update event of the combo box put code similar to the
following:

Me.SubFormControlName.Form.RecordSource = "SELECT * FROM SomeTable WHERE
SomeValue = " & Me.ComboBox.Value
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
"Can't build link between unbound forms" problem 1
Unbound control on continuous form goes blank 1
Update Table via Code 3
Sub Form to Unbound main form control 2
can't build a link between forms 1
How to programmatically build full reference to a control 2
Unbound 1

Top