Cmnd buttons on main form

[davidf]

Hello I have built a data base to tract units. under each unit there is tracts. I have a main form for the unit, and a subform for the tracts. On each form there is cmnd buttons which are next, prev, goto, add new and so on. the cmnd buttons on the main form have stopped working. The only ones that will work are the go to first and the go to last. the add new, comes up with "you cant go there" I have deleted the cmd button and then recreated them but they still want work. Anyone know what would cause this????. all the cmnd button on the sub-form work great. Im Using
access 2007. Also is 2007 compatible with 2010

 

[John Big Booty]

If your command buttons are on the main form but refer to the sub form, be sure you are using the Correct Syntax for referring to the Sub form.

 

[catalin.petrut]

can you attach you db to see the problem?

 

[davidf]

Yes let me figure out how, im new to this forum

 

[davidf]

Here is the file and thanks

 

[catalin.petrut]

I see that the buttons work ok. What is not ok is the relationship betwen the two tables. I suggest that in the tract table you replace unit_name with unit_ID and create a one to many relationship. Then you'll recreate the forms and all will be ok.

 

[catalin.petrut]

That error that you mention is the error message that appear when you are on the last record and you press next record button. The same with the previous record button when you are on the first record.

 

[John Big Booty]

Check this link for dealing with end of recordset.