Diasble Cmd Button...

[zym1ne]

Just wandering if there is an answer to this one...?

Have a Form (frmAdminDetails that updates tblAdminDetails) allows entry of info regards computer admin updating a table, it's unique ID is an AdminID# and it has a relationship with my Main tbl and frm (Dealers by a DID#), you add the data you require then there is a command button that opens a pop-up form to enter the PC Data.

Problem I'm having is:

Pop-up form opens with DID# already assigned via the Admin form (this works no probs)

There can be many instances of Admin for the same DID# but only 1 instance of a PC for a DID#, is there some way of me being able to ''Diasble'' the command button on the frmAdminDetails once a DID# has a record of a PC in my tblComputers (PC Details) after entering PC info via pop-up frmComputers...

Would be great if there is some way...

Can't quite find what I'm looking for on the forums, probably just not selecting the correct criteria

Anyway hope someone can help with this one...

Take care for now folks

Zym

 

[Rich]

If IsNull(Me.DID) Then
Me.MyCmdButton.Enabled = False
Else
Me.MyCmdButton.Enabled = True
End If

 

[zym1ne]

u r a star

Rich

ur a star thanks for that was drivin me crazy trying to figure it out..

many many thanks

zym