473,397 Members | 2,099 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Changing a Validation Rule on a form using VBA code

I am trying to find the best approach to change a Validation Rule for a text box named [txtSerialNumber] based on what a user enters into a combo box named [cboAssemblyNumber] on the same form using VBA code in Microsoft Access.

I am currently a novice in writing VBA code, so any help on this would be greatly appreciated.
Jul 6 '18 #1
1 1210
twinnyfo
3,653 Expert Mod 2GB
jebaker,

Welcome to Bytes!

Rather than "changing the validation rule" on the form, I would recommend simply validating the value entered into the second text box after the value in the combo box has been selected.
Jul 6 '18 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Craig Brown | last post by:
I would like to open selected (Filtered) records in a form. I currnetly have a custom menu but would like to only open certain records from i.e Button 1 will open Site 1 Button 2 will open...
6
by: Chuck | last post by:
A97. A database has a table: tblA which has a single text field, B. It is a primary field, indexed and no duplicates. It is used as a lookup for table tblC. A form based on tblA is used to add...
3
by: BrianB830 | last post by:
Hello all, I have a quick question regarding an MS Access database I'm creating. In the entity "ORDER", I have the attributes "Order Date" and "Delivery Date". I need to create a validation...
0
by: amessimon | last post by:
Hi I have a long form - around 80 fields - which i have decided to break up into more manageable sections using the <asp:Panel> control. Basically i have three panels (stages) containing...
4
by: Segler | last post by:
Hi all I am using a MS DatePicker in an Access form and I am getting the following error message after changing the default date to a new date. "error evaluating check constraint in the...
1
by: vidhyaprem | last post by:
i have started a small project in visual basic regarding the stock details in our textile company.It has details like product id,product name,no of items,product picture etc.. so i have created a...
10
by: gweasel | last post by:
What is the best way to apply a Validation Rule - or rather, where is the best place to put it? Is there an advantage to putting it on the field in the table vs setting the validation rule on the...
1
by: kkk1979 | last post by:
Hi I have been using access 2000. I need help in creating Label controls in an access form with VBcode. Are there Label arrays in access ? can anyone help please ......... Thanks in advance
8
by: Greg (codepug | last post by:
For lack of the proper expression, how do I excite a control to cause events to trigger. I have a date control and am using a calender form button to fill the text box with the date. The text box...
2
by: RachelleB | last post by:
I have one tabbed form that links to a master table. One of these tabs links to a sub form (GRN, to GRN table) and another tab to another subform (SRN, to SRN table). I can run a report that...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.