How to deactivate a command button if record in a query

's Computer Specifications

I want to have a command button on a form to be activated only one
there are no records in a certain query. What is the code for this?
I used to have it but no longer have access to that database.

Thanks,

Matt

's Computer Specifications

Thanks. I wanted it to run after the user pressed another command
button. I changed the typoed period to a comma, and retranslated it
into this:

If DCount("*", "CheckIfInputtedAlreadyqry") > 0 Then
Me.Command6.Enabled = False
Else
Me.Command6.Enabled = True
End If

I had a bit of trouble with it at first because I didn't put the query
name in quotations.

Thanks,

Matt

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying data from current record into a new record using a command button	Scott	Microsoft Access Form Coding	1	8th Jul 2007 07:23 AM
Need to deactivate a command button	Melanie	Microsoft Access Forms	5	23rd Aug 2004 07:03 PM
Deactivate command button by conditionaly	an	Microsoft Access Forms	10	17th Jun 2004 05:08 PM
Duplicate Record Command Button goes to previous record	Bdehning	Microsoft Access Forms	2	9th Feb 2004 06:06 PM
Command Button - to open a new record with some of the data from the current record	Mike Hagstrom	Microsoft Access Form Coding	1	17th Sep 2003 04:17 PM