Search results

Thank you for your help. The box on Form A is actually a text box. I am new to access and unsure on how to implement the requery function in the After Update. Please could you tell me how to do this?

Please help! I have a Text Box called DisposalID on Form A & a Combo Box on a seperate form (Form B) called DisposalID. The combo box is based on a query. Once I add data to the textbox I click on a command button to bring up Form B with the combobox. This form also has a command button which...

Thank you for your help! I managed to follow your advice and the search form works. Brilliant!

Thank you for your help. I have tried the code but keep getting errors. I think I may be putting it in the wrong place. When you say 'AfterUpdate of your Textbox' where exactly are you referring to? I would really appreciate it if you could quote the exact line of coding before & after.

-------------------------------------------------------------------------------- I understand what you mean but I am new to this and don't know exactly where to implement the 'Like' statement. Please could you inform me exactly which part of the code needs modifying? Your help is much...

Thanx I understand what you mean but I am new to this and don't know exactly where to implement the 'Like' statement. Please could you inform me exactly which part of the code needs modifying? Your help is much appreciated.

Hi, I have created a search form which returns only exact matches: Private Sub cmdSearch_Click() Dim strItemNameRef As String Dim strSearch As String 'Check txtSearch for Null value or Nill Entry first. If IsNull(Me![txtSearch]) Or (Me![txtSearch]) = "" Then MsgBox...