Search results

Works fine! llkhoutx, Thanks very much for your assistance. I'm in over my head but I'm trying to understand. I'll be back I'm sure. Thanks for your help, I hope to finish this complex db someday soon.

code That makes sense. Could you give me an idea in how the code might work? I'm a bit confused when it comes to code.

I have an check box option group A:B:C:one of which is the answer to a test question. The results would be like A=0 B=1 C=2. The problem is that the values of A,B and C change on every question and there are 187 questions. The result values are then added together with other question values to...

Thanks alot! I'll see if I can make it work. You guys are the tops!

toggle button I didn't mention that the toggle button is one of two in an option group. There is an After Update in the option group but there isn't one in the toggle button properties. Or maybe I'm just blind???

toggle button I can't find the afterupdate event on the event tab???

I'm trying to use a toggle button to enable a combo box that in turn selects different subforms depending on the entry in the combo box. The default "button on"should leave the combo box enabled and visable. If the default toggle button is not selected then I want the combo box and all the...

Try This This is in the combo box on the form Customers1 Private Sub cboSport_AfterUpdate() Dim ctl As Control For Each ctl In Forms!Customers1.Controls If TypeOf ctl Is SubForm Then If ctl.Name = Me!cboSport.Value Then ctl.Visible = True Else ctl.Visible = False...

Not Yet! Rob, I've enter the code according to your instructions. Whenever I select any sport on the combo box the subforms all go away, and no matter what I select next they won't come back. By the way, you do understand exactly what I'm trying to do. Also, I've doubled checked everything.

Thanks That was a great explanation. Thanks for the help!

I'm still not sure what your saying. I'm still pretty new. The form is called Player, the combo box is called Sport and its list is sports. Baseball, Basketball, etc. Since describing each sport has so many other options (combo boxes) I've elected to use a subform for each sport to provide the...

I have a combo box on my Main Form with several items on the list, lets say, A,B,C,D. When someone selects "A", I want Asubform to come up on the main form. Bsubform when "B" is selected, Csubform when "C" is selected, so on, and so forth. Your help would be greatly appreciated.

Thanks!!!!

Combo Box "PlayerAbility" has "Beginner, Intermediate, Expert in its table. When "Beginner" is selected, I want a certain list to showup in combo box "Level" and combo box "AgeGroup". The same holds true for "Intermediate and Expert but the lists will be different." I think it goes in the...

I'm trying to show the method of payment on an invoice in a text box. The data needs to come from a combobox on a form. I've tried this and no result. =Forms!Payments!PaymentMethod in the control source in the textbox.

I've got a combo box on a form with 5 payment methods in its list. I've placed a textbox on a report that needs to list the payment method that was selected from the form before it was closed. I've managed to get the PaymentMethodID but not the actual text. I've used the following in the Control...

I been trying to show a payment method on a report, but I'm having a problem. Is this the correct statement. =DLookUp(" [PaymentMethodID]","Payments","[Payment MethodID]"="Form![Payments]![PaymentMethodID]")

I've got a standard orderentry database and I want to print the payment method on the invoice. The payment method is on a form(payments) in a combobox(paymentmethod)that lists payment methods, such as: Cash, Check, Credit Card, etc. When I preview the report all I get is "Name?" in the textbox...

I'm using a similiar database to Microsoft Orders. On the Orders form I want the default Sales Tax to be 0 unless the customer is from Texas,then 6.75%. I also want to grayout the Sales Tax unless from Texas. I'm using Access97

I'm extremely stupid today, so I need help. I have a textbox(Cool)on a form named(Contacts). This textbox has a number from 1 to 10 entered in it by an operator. I've got a report generated from a quary from that form named(Contact Quary). That brings up a single file report based on a Contact...