Search results

isladogs, I'm happy to report the code does work, and I think I have uncovered the issue. I want the code to be triggered on a sub form only, so I have placed it on the corresponding form, which when opened directly, works fine, but when its nested in the parent from, it applies the control to...

Thanks Colin, I have put your code into my project, and I do now see what it does...one thing... whenever I click the button to action it, it applies the control to the entire form, so for example: EnableControls False, "7" Disables everything in the entire form.

Hi, Thanks for the pointer. I think my problem is that I am trying to assign more than one value to String2, which is essentially what I want to do. So where the below works: If Me.Parent.Parent.[No: Stations] = "8" Then r = ShowHideControls(Me, "8") What I want is something similar...

Hi everyone, I found a good piece of VBA code on this site to group multiple form textBox and comboBox fields together using the TAG property and then apply the enabled or disabled property to them, based on a selected value from a comboBox. The function is: Function ShowHideControls(frm As...

So..turns out the form I was trying to open had the Data Entry Property set to YES...switching it to NO solved the issue (go to Form Properties - Data - Data Entry). This then enabled the following code to work perfectly: DoCmd.OpenForm "FrmCustomerExisting", , , WhereCondition:="[Doc ID]=" &...

I agree...but as I said..it opens the right form, but to a blank record. I am totally perplexed!

[SOLVED] VBA Open Record to Form Hi there...I have an issue I'm struggling with...hoping someone can help. I have a Query that outputs a simple list of records in Datasheet view, and I have an embedded macro that opens an individual record from that datasheet in a Form when you click on...

I tried both the VBA and form property recommendations, and both ideas worked in slightly different scenarios. The Form property option...In("10","11","12","13","14","15","N/A")... worked exactly as it should for the exact values specified. The Form property option...>="10" And <="15" Or...

Thanks for the advice. I was attempting the validation on a text box on a from that is bound to a table. I was using the text box’s Validation rule property. I hope that clears up the issue.

Thanks very much for the replies and advice. I have been trying with the validation rule property. Using variations of my initial example. Is VBA the best / only way to achieve this? If so, thanks very much for the help.

Hello guys, I have a particular problem that I am struggling to figure out. I would like to validate a form text field with two criteria, one number, and one text, for example: Between 10 And 15 Or “N/A” The intended outcome is any number between 10 and 15 is allowed, and any number outside...