sub form coding problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I have an UnBound form with SubForm - e.g. Main Form - text box with a Room
No. in it - 1 or 2..... there are cmdNext, cmdPrevious buttons
I wish - when room No.1 or 2 or 3 etc appears that the sub form shows
relevant machines in that room from a Query - 'qryMachines'.
Using Debug.? it works fine, in other words I have managed the
Select....Where etc. part. How do I construct code to actually places the
results into the SubForm please ? I did it using a list box but do not like
appearance. I have scoured forums - to no avail
Thank you very much for any help !!
Al
 
If you want to filter the subform based on a value in your main form, you
can set the Link Master/Child properties to the common value/field/control.
 
Thanks for reply Duane - I have tried that - but Access comes up with MsgBox
"Can't build a link between Unbound Forms" ?

Al
 
You don't need to use the builder to set the link master/child properties.
Just type in the common value/field/control in the properties.
 
Duane - Thank you so much !!! I would never have thought of that in a million
years, not in books either (I Don't think ?)
Spent quite a few hours on this problem, luckily too stubborn to give up !!
Thanks again ( on to next headache now !!)
Regards,

Al
 
Back
Top