Data Edit Form

[labprof]

I have a data entry form that is based on a table called CofC_tbl. In the table there are a few fields that are combo boxes that I use on the form with drop down options.
There is an autonumber field call CofCNum that assigns a number to each record.
After the data is all filled out on the form I have a command button on the bottom to select to close the form.

Frequently we need to get into the data and edit some of the data. So I just made a copy of the first form but instead of it looking at the table I created a query so that we could call up just the specific record. So in the query grid for the field CocCNum I wrote [Enter C of C #].
So I call or open this form from a menu. When they select the button Edit Data on the menu it first asks them to enter the c of c #. When they enter the number the correct C of C record comes up with all the correct data.

Except..... for some reason it will not allow us to edit the data. I've looked and there are no record locks, the form is not in data entry mode.... what else could be causing this.

Any help would be appreciated.

Labprof

 

[Pampers]

...I created a query so that we could call up just the specific record

Make sure the query is updatable. View the query in datasheet view and look of if the record navigator 'new record icon' is turned on (black instead of gray). If it is gray, your query is not updatable.

Pampers
Keeping it simple can be complicated

 

[TheAceMan1]

How are ya labprof . . .

Set [blue]RecordSource[/blue] of the edit form to a normal query then add a combobox to the form using the combobox wizard (select the option [blue]Find a record on my form . . .[/blue]).

See Ya! . . . . . .