Load only one record in combo boxes

[Lateralusx777]

I realized a combo box wasn't the best way to go about this since we are looking for unique tag numbers and there are 440,000 of them. I used a text box as a search box and put it on the AfterUpdate of that.

[Gicu]

So it works now?

[Lateralusx777]

It does not.

[Gicu]

Can you please post the full code you have for the form? Screenshots of the form in design view showing the searching textbox name and form's record source would help.

Cheers,

[Lateralusx777]

Me.RecordSource="SELECT * FROM Tags WHERE [Tag#] = " & Me.cboSearch
that is in After Update

SELECT * FROM Tags WHERE True=False is the record source

text3360 is the search box name

[Gicu]

Please try:

Me.RecordSource="SELECT * FROM Tags WHERE [Tag#] = " & Me.text3360  'assumes the [Tag#] field is numeric

Cheers,

[Lateralusx777]

Still says cannot find object me.

[Gicu]

The code needs to to in the form's module, can you take of screen shot of the code window?

[Lateralusx777]

Here is the form.

[Gicu]

Aha, thanks for that. You need to remove what you have in the After Update property and choose "Event Procedure" from its drop down on the right. Then click on the builder (the ... on the right) and it will open the VBE window where you will see something like this, it is there where you add the code:

Option Compare Database
Option Explicit

Private Sub text3360_AfterUpdate()

Me.RecordSource="SELECT * FROM Tags WHERE [Tag#] = " & Me.text3360

End Sub

Cheers,

[Lateralusx777]

I did that and it is still the same issue. I am going to find a different approach to this.

[Gicu]

Same issue like in cannot find the object Me (this cannot happen if you put the code in the form's module) or the same issue like in crashing?

[bubai]

I am not sure how to make my form load without records without applying an on load record filter which then needs removed to display results.

Make Data Entry = Yes on the forms property sheet on the Data tab. This will stop all of the records from being displayed. OR if you do not want any filter on load clear the filter property or change Filter on load = No.