Search results for query: *

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...

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...

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?

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...

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...

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...

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 =...