Access Form Search

Hello, I could use some assistance. I am trying to create a search/filter for a form but it is not working.

The database I have created is an inventory database. The only complexity is that the field "Location Initials" in the "Assets" table pulls values from another table called "Locations."

In my form, I am trying to do a search of assets based on where they are located. I am using a combo box that pulls the locations from the locations table to perform the search.

I created something like this over a year ago but cannot remember what I did and do not have access to that resource. From what I can tell, I have to create a query to search by in the VB code for this to work.

Any help would be greatly appreciated while I continue to work on this issue.

Review these tutorials:
http://datapigtechnologies.com/flashfiles/buildcustomfilter.html
http://datapigtechnologies.com/flashfiles/searchform.html

One way to show the location associated with asset is to have the form's RecordSource be an SQL that joins Assets and Locations tables. This will make all related data available for display on the form. The search combobox should not be bound to any field.

Then apply the principles from the tutorials to your form.

Is this form to be used for data entry?

One way to show the location associated with asset is to have the form's Record Source be an SQL that joins Assets and Locations tables. This will make all related data available for display on the form.