Hello,
I've read thru numerous post/archives trying to decipher the cause of my problem to no avail. I'm just basically trying to conduct a search by using a form in order to locate data that may or may not be in one field of an associated table/query. Here's my 3-step process.
1) I click on the name of my Main form (that I've already created along with a subform and query and an click-on command button) and it prompts me with an "Enter Parameter Value" diablog box. 2a) If I enter a username that I know is there, the Mainform appears with data results only populated in the Subform area (nothing gets populated in the Unbound TextBox control area). 2b) If I enter a username that I know is NOT there, it returns a data entry screen with all fields blank (empty) or it clears out the previously populated subform area conducted by a previous search, which is fine. 3) When I try to conduct my second username search (on a different and known username) from within this MainForm/Subform area by entering data in the Unbound TextBoxControl field and clicking on my customized Command button, I am then prompted again (just like in step1) by the "Enter Parameter Value" dialog box so that I can re-enter the data that I just tried to enter in the Unbound TextBoxControl.
The search does retrieve the appropriate data but I have to initiate the search in such an awkward two-step manner that it makes me wonder why I even need the UnboundTextBox Control in the first place.
Any suggestions would be greatly appreciated.