Using access for small CRM database

[grichey]

I don't know what I should be searching / asking for here but here's what I'm going for.

I'm fine w/ setting up access databases, but what would you use to make a front end so the a coworker with no knowledge of how to make a query could use this?

[CreganTur]

Can you provide more detail about what you are trying to do?

[grichey]

So i want to make a database with a the fields
Name
Address
Tickbox checked or unchecked
State

I want to be able to then use a combo box or something (which I have never messed with) to say view all records and modify that have state = TX.

[CreganTur]

I want to be able to then use a combo box or something (which I have never messed with) to say view all records and modify that have state = TX.

Ahhh, got it. This can be done easily.

First, make your form's Record Source a query. In the Criteria section of your State field, enter the following:
[Forms]![FormName]![ComboboxName]
where FormName is the form's name, and ComboboxName is the combobox's name.

Then click on Query-> Parameters. Enter the exact same string in the first column, and select a data type for the second column. Then click Ok.

This will link your query to your combobox, so that it will pull the combobox's value into your query and use that as criteria automatically.

On your combobox's on change event you will need to use Me.Requery- this will requery the results from the query so that they show changes that match the combobox choice.

HTH:thumb