Help With DLookup

[NickS]

This is my first post, so be gentle...



I've read a lot and searched for an answer to this but, no joy.

I have a form (data entry) in which I'm trying to include a search box (text). I've gotten most of the way there, but I'm getting a #Type! error in the search box after inputting the DLookup function into the Control Source property.
Attaching a screenshot. Hope it comes through clear enough.

[pbaldy]

See if this helps:

DLookup Usage Samples

Don't forget to use your field name, not "Criteria".

[NickS]

Your suggestion about the "Criteria" was spot on. Now I cannot edit the text to do a search in the box.

[pbaldy]

Not with a formula in the textbox. Sounds like you want an unbound box for entry, another to display the result. Have you considered a combo box? Particularly if you want the form to fill out with the record. If that's the case, try the combo wizard, choosing the third option, "Find a record...".

[NickS]

Ah...I'll give that a try

[Bulzie]

I agree with pbaldy on using a combo box, include the tool number and maybe tool name, then when they select it from the combo box field, do a form filter using tool number to display that specific tool info.

[NickS]

I'm a noob, so pardon the question...but how do I filter the form on the search box results?

I've got the combo box in place. It does work.

[NickS]

One thing I noticed is that the combo box wizard only allows me 2 options. The 3rd option for finding a record based on the selection is missing.

[pbaldy]

The form needs to be bound directly to a table to get the third option.

[NickS]

Now the form does not display any records at all.

[pbaldy]

Is the record source of the form a table? Did the Data Entry property get changed to Yes?

[NickS]

That was it. Records showing now.

On another note...I found a video using a text box to search. Includes a macro to SetFilter by the text entered into the text box after update. I've got it semi-working except when I enter text and hit enter, an "enter Parameter" box pops up. If I enter the same text again, the filter works. How do I get it to take the text entered into the box initially?

[pbaldy]

The parameter prompt is Access telling you it can't find something (whatever is specified in the prompt). Perhaps something is spelled wrong? What's the code look like?

[NickS]

[tblToolPrgsToolNum] Like [txtSearchToolNum]

Embedded macro set at the After Update for the text box in the Where box. "txtSearchToolNum" is the name of the text box used to type in the search criteria.

[pbaldy]

Looks okay, but I don't use macros. Can you attach the db here to play with? Maybe it needs the full reference:

[tblToolPrgsToolNum] Like Forms!FormName.[txtSearchToolNum]

replacing with your actual form name.