Control buttons will not work

B

BillD

I am having a problem that I can't find the source to and need some help. I
have a form set up in a tab (4 tabs- Contacts, Registration, payment,
Contribution)
In the main form Contacts I have Control buttons for: First Record, Last
Record, Find Record, Previous Record, Next Record, Close

Here is the problem: The First Record button and the Last Record Button when
clicked do nothing. The Find Record Button when clicked gives a message box
"You Can't Use Find or Replace Now" The Previous Record and Next Record
buttons when clicked give the same message "You Can't go to the Specified
Record" The close form button works fine.

I cannot find out why these buttons don't work. I tried creating another
button and those do not work either.

Here is a copy of the Find record code and Previous record code if anyone
can help please advise thanks

Private Sub Command63_Click()
On Error GoTo Err_Command63_Click
DoCmd.GoToRecord , , acPrevious
Exit_Command63_Click:
Exit Sub
Err_Command63_Click:
MsgBox Err.Description
Resume Exit_Command63_Click
End Sub

Private Sub Find_cmd53_Click()
On Error GoTo Err_Find_cmd53_Click
Screen.PreviousControl.SetFocus
DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
Exit_Find_cmd53_Click:
Exit Sub
Err_Find_cmd53_Click:
MsgBox Err.Description
Resume Exit_Find_cmd53_Click
End Sub

Thanks in advance for you help
 
B

BillD

At the present time there are only two records on the data base I started
filling in the information had to close the program and when I opened it
again then opened the form there was no information showing on the contacts
form. I then clicked first record and nothing happened, I then tried clicking
the other record buttons and either nothing happened or I got the above
messages.
I don't think I turned on any filters. I am fairly new to Access and am not
sure where to look to check for filters can you advise on that.

Thanks for your time
 
B

BillD

I started messing around with the filter drop downs . When I opened the
Advance Filter/sort I noticed a filter titled Filter 1. The field name was
"Inactive Contacts" and the Criteria was "0 and 0 and 0". When I clicked on
Apply/sort Filter then checked the form everything was working fine.

Thanks for heading me in the right direction I was really worried I had a
major problem and may have to rebuild the entire database.

You folks are the greatest.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top