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!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by awesomet

  1. awesomet

    combo applying filter

    Noep , nothing yet...resorted to the opening a new form idea and displaying the results from the combo... Dim stDocName As String Dim stFilter As String stDocName = "awesome_view" stFilter = "[Section] = '" & Me![section1] & "'" DoCmd.OpenForm stDocName, , stFilter...
  2. awesomet

    two subforms in one form

    Awesome....thank you
  3. awesomet

    two subforms in one form

    Can you have two subforms in one form... One displaying a data sheet view of all records and the second subform displaying what id double clicked in the first subform...?
  4. awesomet

    combo applying filter

    ouch even after all that I am still not getting it... OK no new form I want it to stay in the same form... have this now: Private Sub section1_Change() Dim section1 As String DoCmd.ApplyFilter , "section1 = 'Section'" End Sub section1 is the combo name section is the field...
  5. awesomet

    combo applying filter

    Hi Misscrf Thank you..the subform is set up as a subform datasheet. You mentioned datasheet being ideal and requerying the subform where combo= comany field on subform...? Can you then help with the following where condition: Forms![awesome_home]![section1].AfterUpdate =...
  6. awesomet

    combo applying filter

    The combo boxes contain values of a control source of the sub form if that makes sense.... IE: drop down box is a list of companies and I would like to filter the sub form by the name of the selected company in the drop down box.... The drop down boxes have values in them that appear in a...
  7. awesomet

    combo applying filter

    Hello ... Need help in applying a filter to a form. The info is sitting in a sub form (dataview) and I have a few various drop down boxes that I have with a few value lists in them and would now like to set up a filter after update action in them... I am here at the moment with no idea...
  8. awesomet

    Double click in sub form

    Hi Recordsource is "awesome" same the thesubform... all sorted...; ) Thank you
  9. awesomet

    Double click in sub form

    Hi There was a problem with the awesome1 form all sorted and working now... Thank you all...
  10. awesomet

    Double click in sub form

    Hi Did try both the command button and the message box however I still have the same error....the sub form is in dataview displaying the records... The [paxID] is displayed in the message box so it is taking the linking code correct ? I am stumped ? Thanx
  11. awesomet

    Double click in sub form

    Hi Wow that is a cool trick and got code now however the error is still coming up: However it is coming up with an error:Run time error '3709' The search key was not found in any record ? My code now looks like: Private Sub paxID_DblClick(Cancel As Integer) Dim stDocName As String...
  12. awesomet

    Double click in sub form

    Hi Thank you for the reply... OK trying a diffrent way and moved it to the control, in this case [paxid] Private Sub paxID_DblClick(Cancel As Integer) DoCmd.OpenForm "awesome1", , , "[paxID] = " & Me!paxID End Sub However it is coming up with an error:Run tim error '3709' The search...
  13. awesomet

    Double click in sub form

    Hiya need some help with some code please...need to double click in a sub form that will open in a form and display the double clicked record...I have the following but it is not working: Private Sub Form_DblClick() DoCmd.OpenForm "awesome1", , , [paxID] = Me![paxID] End Sub Thank you
See more

Part and Inventory Search

Back
Top