Simple search?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ryker - 03 Jan 2007 17:32 GMT

Is there a way to code the following?

I have frmIntake which is linked to tblIntake. I want a search button
on the form to search the table for Last Name which is entered for the
search. I want all instances of this name to be displayed where the
appropriate one can be choosen to populate frmIntake.

I am new to VB and I can't figure out how to code this.

Thanks

Reply to this Message

Larry Linson - 03 Jan 2007 21:13 GMT

> Is there a way to code the following?
>
[quoted text clipped - 4 lines]
>
> I am new to VB and I can't figure out how to code this.

I hope you mean you are new to "Access and VBA" not the separate VB product.
If the latter, you need to find a newsgroup for that product.

If the former: The simplest way to do what you want won't require you to
write any VBA... make sure the "magic wand" on the Toolbox is selected, then
click the little cryptic symbol for Combo Box (there's a tool tip, in case
it's difficult to determine). Then, put the cursor in the Header of your
Form, and follow the prompts from the Wizard...

The Wizard will generate code for you, unless you are using Access 2007, in
which case it will generate <UGH!> macros.

Larry Linson
Microsoft Access MVP

Reply to this Message

Tom van Stiphout - 04 Jan 2007 02:40 GMT

<Shudder> Is that true about macros? That would surely qualify to be
added to Allen Browne's list.

-Tom.

> > Is there a way to code the following?
> >
[quoted text clipped - 19 lines]
> Larry Linson
> Microsoft Access MVP

Reply to this Message