Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Viewing subforms
It was simply because I had the subforms set to Read Only... I can't believe I've been so stressed over this for days and it was so simple. Thanks for your help.- bjcountry
- Post #8
- Forum: Microsoft: Access Forms
-
Viewing subforms
Please note in the above code, the cmdTractInput should actually be cboTractInput (combo box not command button). Thanks.- bjcountry
- Post #6
- Forum: Microsoft: Access Forms
-
Viewing subforms
Well when I convert the macro to VBA this is what it looks like: Function mcrTractSearch2() On Error GoTo mcrTractSearch2_Err DoCmd.OpenForm "frmTracts", acNormal, "", "[TractNumber]=[Forms]![frmTractInputCombo]![cmdTractInput]", acReadOnly, acNormal DoCmd.Close acForm...- bjcountry
- Post #5
- Forum: Microsoft: Access Forms
-
Viewing subforms
I have the input box and combo box set up with a macro on an update event to open the Main Form. The WHERE statement in the macro is set so the ProductID (for example) entered or selected from the input box or combo box equals the ProductID record that opens in the Main Form. The subforms work...- bjcountry
- Post #3
- Forum: Microsoft: Access Forms
-
Viewing subforms
I created a main form with a tabbed folder on it. On the tabbed folder there are a number of subforms which all relate to the main form. The main form is working properly. I created another form which allows the user to pick which record they would like to view from either a combo box or...- bjcountry
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
