Recent content by MeisterGirl

I set up a combo box to allow users to search through product options and I have a filter options box that will allow them to select a specific product type. The problem is that inorder to make them work I had to go into the form properties and reset my for to Allow Edits. Once I get all of...

Okay - I am almost done with the form. I'm sure you guys are glad to hear that! I have 4 business rules that I have been asked to incorpoarate into the form - here is what I need to finsih up... 1. A value for Intr_Code is required ONLY if Prod_Grp = EA or TR. Code for this? 2. If Month_Fee...

Awesome - I'm actually learning things - I changed my mind on how to use that function and placed it elsewhere in my form and even added a message for my user - there is hope for me yet!!! Don't worry - I'll have more questions!!! Try not to miss me too much!! Talk to everyone soon!

Okay - who's ready for the next dumb question from the MeisterGirl??? Remember there are several Happy Hour drinks up for grabs!! Here goes: I have a filed called Prod_Grp and depending on what the user selects from the look up box I want o set requirements for three other fields. Example: If...

Well - Stay thirsty because I have more questions to throw out there before Happy Hour!!! If I knew the proper syntax and word use I wouldn't have such a problem becasue I understand the logic - it's just writing it down!!! Anyway - thanks for all your help - I'll probably be hearing from you...

Worked Beautifully!!! Thanks Guys!! Pretty soon I'm going to have to start buying drinks for you guys!!!

I have the following lines of code written behind my form: If Prod_Grp = "EA" Then Serv_Cd = "STD" End If If Prod_Grp = "IN" Then Serv_Cd = "800" End If If Prod_Grp = "HD" Then Serv_Cd = "HMD" End If If Prod_Grp = "TR" Then...

I have a field that needs to sync up with another field. For the sake of discussion we'll call them "Code" field and "Type" field. What is the code I would need to make it do something like this: If 'Code' = EA Then 'Type' = HMD or If 'Code' = IN Then 'Type' = WAT. I have 5 different 'Code'...

The code worked and I am able to start entering data now! Thank you so much!!

Here's more detail on the Form: I have one field where I enter a rate. Then I have 50 fields - one for each US state. Our Data Warehouse requires each state to have it's own field for querying purposes. 9 times out of 10 the rate is the same across the board - occasionally one or two states...

This is probably so easy for someone else but not me.. I have a form in which I need 50 fields to populate automatically after I enter a value in a specific field. Each record will contain different values so I can't use the "default" setting because that carries through to other records...