Search results

(My Skill Level: Newbie)

I have a form that includes a basic macro-based "Save" button. Building VBA code on the OnUnload event that: A) Prompts user to complete required fields if "Save" button was clicked. B) Checks if "Save" button was not clicked. Then, verifies if user really doesn't want to save...

I simply made new fields in query design that concatenated a several fields in my query. I was then able to run searches with or without spaces. Cheers all.

Figured it out and got it working perfectly with the multi field & multi text criteria. Thanks.

Your DB is awsome. Can't get over how cool it is. I'd like to have users search one or more fields at once with a space added in between. For example: Bldg or Bldg_CompassPt or Bldg_CompassPt_Street or Bldg_CompassPt_Street_Artery I tried adding side by side criteria for each field...

To build on the example, I'm imagining some type of OnClick event where I click on the row I want, but a form opens up with the matching data with my table as a record source (instead of the query).

Thanks for that example. Your suggestion solves my search & find issue... But not my (table) edit issue. I need to search, find, then edit the source table, but in form view. As far as I know, I can't edit query data. How can the code in the example be manipulated to search and point to...

Sorry. I tried posting a new thread, but couldn't find out how to do it. Thanks for replying. VBA Experience: Low DB Purpose: To provide a main form & subform where users can search for and update records in a table, respectively. It is important to mitigate user input error. Users...

I need to do the opposite: Have a main form search an editable subform (with table as source). I have code that uses a form/subform combo to do a a search & view, respectively. However, I need to view & edit after the search is performed. As such, I'd prefer to have a table be the subform's...

I have code that uses a form/subform combo to do a a search & view, respectively. However, I need to view & edit after the search is performed. As such, I'd prefer to have a table be the subform's record source, but I'm not sure how to alter the code to search the table. I ultimately need...

that's IT! thanks a million!

Hi- I have a form/subform relationship that should allow users to enter search options on the main form, click a search button on that same form, then view & edit the results in the subform. I've tried every iteration of "Me!, Me., Me!MainFormName!SubFormName.Form. (and !) RecordSource"...