Olah,

I have created a form that has a button to open a table. The table has multiple fields, but I want the user to only be able to edit one field. Is there a way to do this? I've been toying with the OpenTable method, but I've only been able to assign edit or readonly to the whole table.

Thanks,

Dave

Use a form instead of opening a table. Your users should not see tables or be able to edit them in table / datasheet view. You can base your form on a query, or pass a parameter to the record source and open the form with only one record showing.

HTH

mmcdonal

OK. I've created a form with text boxes that are bound to the fields in the table. But, I haven't been able to make all of the records show. It will only show one at a time and then you have to scroll through them. I want the user to be able to see all the records at the same time b/c they have to look at them to compare. I've made a form that does this before, but I can't remember how it worked.

I figured out how to make multiple rows show on my form:)
I just had to drag the footer bar up to where it was just below the text boxes. Now it shows all the records and my form is good to go!