Search results

I have 2 toggle buttons on a form that return a value of 1 or 2 to a table. I have another column in the table that needs to have 10% if 1 or 20% if 2. I have tried writing if statements in the expression builder but i cant seem to make it work. The column that the value from the toggle is...

Thank you I got it figured out.

No i have not tried a on load event but i think that would take care of it. I tried playing with the code that you posted but it would not work. If I could just get the form when it opens to default all of the combo boxes to the new record instead of the last record i think that would fix it...

On the Form ther are 3 combo boxes. 1. Select Customer # 2. Select Sport (NCAA Football, NFL, NCAA Basketball, NBA) 3. Select Team Then there is a text box where you enter the line. Now click Log Bet. I am trying to keep up with all the bets placed. This information should go to a...

Thank you for your help. The code did what i was trying to acccompolish but I still have this problem that when it records all the information to the table it writes over the previous record. I think this has to do with using the control source feature in my combo boxes. Do you know a way...

I have the following code and it will work independent of each other. How do I combine it so it records the information, closes 1 Form and opens another form? I appologize but I am a idiot when it comes to VB. Private Sub LogBet_Click() On Error GoTo Err_LogBet_Click DoCmd.GoToRecord ...

Is there another way to do this. I'm guessing since we are selecting ControlSource. When you open the form the list boxes are automaticlly populated with the information of the first record in the Table. When you enter a new record it writes over the first record and then it continues to add...

1. It will never be used to edit an existing data field. 2. Private Sub Command32_Click() On Error GoTo Err_Command32_Click DoCmd.GoToRecord , , acNewRec Exit_Command32_Click: Exit Sub Err_Command32_Click: MsgBox Err.Description Resume Exit_Command32_Click End Sub

I have a form with list boxes and a button. 1. Customer # 2. Sport 3. Team Button LB This information gets logged into a table with the following fields. Customer # Sport Team Bet# "is set to (autonumber)" PROBLEM when i close the form and open it back up it always writes over the first row or...

I should be able to get it figured out with the file that you posted. Thank you so much.

If this is posted twice I am sorry. I poste a response about an hour ago and it never showed up. I tried a new form with combo boxes and I am still lost. There are 5 list boxes on the form and I first need to get all the information selected and then click a button that will log all of this...

I have 2 list boxes where the first one selects a category and the next one selects a product. Once the selections are made i need to be able to click place bet and get this information into a table "loggedbets". I am completly lost on this. Below is the code that links the list boxes. Private...

I have 2 list boxes where the first one selects a category and the next one selects a product. Once the selections are made i need to be able to click log bet and get this information into a table "logged bets". I am completly lost on this. Below is the code that links the list boxes. Private...