Help with Form

[bladeuk]

Hi Guys,

I have a form where I want to be able to enter a reference number (free text) and then run a report detailing any entries in my main table that match whatever I enter.

I've done sub forms to select agent ID's from a combo box etc. and they work fine, how can I get it to find whatever I enter as the search requirements?

for example - field will have a numeric reference of 8 digits. I want to enter this 8 digit reference , click a button and have a report display all records that match this reference. Note - it could be many times and is not the record ID, just an entry in a field.

Does this make sense?

Thanks in advance - no expert in code by the way

 

[Montez659]

How about a query on the table and have the criteria for the field you are trying to search refer to the textbox input? The criteria would look something like this:

=[Forms]![YourFormName]![txtboxName]

And then add a command button that would trigger the query via Macro when clicked.