Recent content by GabrielR

In the AfterUpdate event of the Control that defines if the field has to be enabled or not: If Me.Field = "Value" Then Me.YourField.Enabled = True Else Me.YourField.Enabled = False End If

search in the forums for Cascading combo... There is anoter example Here

Yeah have had that one before.. Try Private Sub Form_BeforeInsert(Cancel As Integer) If Not IsNull (Forms!frm_Menu_Create_CR!cbo_Parts) Then Me.[Part Number] = Forms!frm_Menu_Create_CR!cbo_Parts Else: End If End Sub

Try this: Me.Yourcombobox = Null [CODE]

Not a very elegant workaround What you need is to set Conditional formatting, unfortunately Command buttons do not support that feature.. Maybe in the next version of Access :confused: Well there is a work around to that, but before let me state that Ihave found that putting controls inside...

Then is much more easier... See attachement

mmm I think it could be something like (from the top of my head) : in the OnCurrent Event of the Subform If Me.Checkbox = -1 Then [Forms]![YourForm].[Yourbutton].Enabled = True Else [Forms]![YourForm].[Yourbutton].Enabled = False

can you post a stripped sample of your DB? I think I get the Idea, but it would be simpler if you give us a little sample to work with

Not quite sure, but it could be the Autoactivate property. Anyway, storing pictures on a database has shown to be not a very wise practice. I would suggest you to store the Path of the picture and have the image bound to the path of the picture.

Hi, Welcome to the forums.. It depends on what you want to do.... 1. If you only want to disable the button after clicking it is fairly easy, but then everytime you step in a different record the command button will be back to its original state (enabled) 2. If you want to disable the...

If I understand you correctly, you need to print the records that have the checkbox received unchecked, is that right? You need to base your Report on a query that select the records that have No on that field, and criteria to select only the records for the supplier on the screen. As I told...

Let me ask in which case would you want to alter the design of a form on runtime? I am sure there are ways around watever conditions that needed to be met to avoid the headache of doing that.....

You can add controls and set their property to Enabled/Disabled or Visible, and set their values on during runtime operation.

You can go to Form Properties and under the "Other" tab, set Cycle = Current Record.

Do this on a brand new blank db just for the sake of learning... This may be your entrance to the wonderful world of writting code. Follow the steps carefully... one by one.... If you are stuck at a particular step, just chime in and we will get you through it... Do not worry it is easier than...