search field on form

[jansenonline]

Hi,
I'm sorry if I sound like an idiot. I've been using Access for only a few days now.
I've created a database with multiple tables. And I have created a querry using columns from both these tables.
Then I created a form based on that querry, where I see all the relevant data of those (linked) tables.

My problem now is that I want to place a search field / command button in this form. Where a user can type a search term and the entry's are filtered based on this search.

I've read about a milion simple tutorials, all state: place a command button and use the wizard.

However, I started this database using the 'Projects' template already in Access, therefore all my databases and forms are webdatabases. And this prevents that wizard from running. In a simple, empty database it works like charm, but not in the one I need it to work in.



So my question is:

How do I manually program the command button to take the value typed in a textfield and use it as either a filter or a search inside the current forms.

All help would be much appreciated!!!

[June7]

Here is one method to filter form http://datapigtechnologies.com/flash...tomfilter.html

However, AFAIK web database can't use VBA, must be macros (embedded or regular).

[jansenonline]

Hi,

thanks for your help. I've tried to follow this tutorial. But unfortunately, using web databases I can't set a bound column (option doesn't show up in properties window).

Without it, the combobox doesn't work.

Any other thoughts on how to make this happen. The most annoying thing is that in the customer list that came with the template, there already IS a search field, that works fine. Differences being that it searches in a list view, but that's the only thing.

Grtz

[June7]

Sorry, I never built web database. Not familiar with 'list view'.

[jansenonline]

My bad, just my noob way of expressing the way the form looks. I mean to say that the build in customer form with the search field shows all the records on one page, where as the form I want my search field on shows one entry at a time.

[June7]

Search should work the same whether form is set to Single or Continuous view.

The issue is with the combobox. Why do you need to set the BoundColumn? Do you want the combobox multi-column? Just make the first column the field to use as criteria in search, probably an ID primary key.

Should be able to set ColumnWidths and ColumnCount.