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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. superljl

    Microsoft Office Access can't find form...

    If it's open, I don't know how it's being opened. Here's my process: I launch Access, I open the mdb, I launch my switchboard and choose an option from a listbox. My listbox choice [AfterUpdate event] sets the recordsource (a parameter query) for my results form, the parameter input box pops...
  2. superljl

    Microsoft Office Access can't find form...

    Thanks for all your help, everyone, but I created a new database with my main table and was able to get back to where I was before the "renaming the form" debacle. I can now link the recordsource to the form without opening the form first. Making the form hidden then visible wasn't working for...
  3. superljl

    Microsoft Office Access can't find form...

    Okay, thanks! I haven't messed around with OpenForm much and didn't realize I was putting it in the wrong place! Now, how do I "unhide" it?
  4. superljl

    Microsoft Office Access can't find form...

    Thanks, Remou. I did play around with that, but the form kept opening in design view(?). Here's the code I used: DoCmd.OpenForm "frmInv", acHidden Is that incorrect? And, can you tell me, once the form is hidden, what's the code for making it visible? I don't want to open it again and...
  5. superljl

    Microsoft Office Access can't find form...

    The code was working (before I renamed the form) linking the recordsource BEFORE opening the form. I swear! The recordsource query I was attaching (a parameter query) would run, I'd answer the question, THEN the form would open. Now, if I switch those two lines in the code, the form opens...
  6. superljl

    Microsoft Office Access can't find form...

    Remou: It was working before without opening the form first. I don't want to see the form with no data in it. Adalger: The name of the form now is frmInv. I've looked everywhere I can think of that might have the wrong name and I can't find any instances of the wrong name. I'm stumped. If I...
  7. superljl

    Microsoft Office Access can't find form...

    I've got a form with a listbox built on the fields of a table. On the After Update event, I've got this code: Private Sub lstQueries_AfterUpdate() Dim LinkCriteria As String On Error GoTo Err_lstQueries_Afterupdate LinkCriteria = "qry" & lstQueries.Value Forms!frmInv.RecordSource =...

Part and Inventory Search

Back
Top