Recent content by svbl

yes, the checkbox is a field in the form's table I originally had it unbound because I thought I would only need to view it through the form, but I later realized I needed it for query reasons so I made it a field.

Thank you for being so patient with me Rich. I think I found the reason to why your code's not working for me. After deleting the other codes and just keeping the one you provided for me, it works perfectly fine, like how I described it. However, maybe this is the reason why it doesn't work...

I also have other codes in the forms On_Current event for other actions.. Private Sub Form_Current() Me.cmdOpenBiop.Enabled = Nz(Me.chkBiopsy) If Not IsNull(VisitDateNB) Then Me.MedianDML.Enabled = True Me.MedianDMLleft.Enabled = True Me.MedianCVmotor.Enabled = True...

Thank for you help, but it still does not seem to work. I'm not receiving any error message, but when I open the form, the txtbox control is still disabled even when there's a check in the checkbox.

An error message of, "Invalid use of Null" appears.

ok, i thought Ray's suggestion solved my problem, but it apparently did not. Here's the problem, I put this in the On Click event of the checkbox control: If me.checkboxname = true Then Me.txtboxname.enabled = True else Me.txtboxname.enabled = false End I during data entry, when I click...

That was easy! Thank you Ray and thisisntwally!! =) I've been fooling around with the same code, but my problem was not being sure what to set the chkbox value as.... the part bolded in blue: If Me.txtName.Visible = True then I kept putting in "value" then "Yes/No" and I knew "Text" would not...

Hi there. I'm not sure what to reference a check box as. What I mean by this is.. I have a checkbox and a text control (the text control is disabled upon entering the form, but the check box is not). What I want to happen is if I click on the checkbox (with a check in it) then the text control...

Hello. I'm not sure if this is even possible, but just thought I ask those of you more experienced with Access. I created security for my database using Access' User-Level Security. What I'm wondering is if it's possible at all to create a command button in my database where I can have...

Thanks bob. For others in the future wondering the same thing, I found a solution to my problem. I tried setting the forms Pop up to yes and it works ok.

Hello. I have a form that has multiple command buttons that, on click, would direct me to other forms. In my Main form, I put the auto maximize code in it's Open event: Private Sub Form_Open(Cancel As Integer) DoCmd.Maximize End Sub the problem is, when I open the other forms through the...

Hey thanks for both reply! I tried switching the Modal to Yes first and it works!! Thank you =)

I have a Main form with other controls on it and a command button that opens up a small form. On this small form, I have a SAVE and CLOSE button. How do I make it where the focus is set on the small form UNTIL I press the close button? Meaning, once I open the small form, I would not be able...

Hello. I have a text search form. When I enter in a value (text value) that pertains to a certain control on my form and press search, if such a record exists, the information in the controls will change accordingly to my searched text. It's a search control that only relates to that form. The...

Easy and simple, Thank you!