Recent content by magster06

Is the following code ok, or do I need some code in the BeforeUpdate Event? Private Sub cmdSaveEMS22_Click() intAnswer = MsgBox("Are you sure you want to save this record?", vbQuestion + vbYesNo, "Save Confirmation") If intAnswer = vbYes Then DoCmd.RunCommand acCmdSaveRecord...

Thanks for the replies! I'll try a different approach.

Hello all! The following code was working, but I was experimenting with some different ideas and decided to go back to my original setup. Unfortunately, the code does not want to cooperate anymore. When it would ask if I want to "Save" and I click "No", then it would clear the data and not...

Uncle Gizmo, Thank for your response and suggestions. I think I am going to try your first suggestion as I would like to keep my original form design. Thanks again for explaining about the combo box.

Hello all, When a user selects a name from a combo box then 11 textboxes are populated with personal information. What I am looking for is when the user edits the persons information (i.e. changes the persons phone number to a different number), how do I update the table with this...

vbaInet, Your idea worked! I placed the following in the GotFocus event of the listbox that I would be making a selection in: Me.listbox that I am leaving.Selected(0) = False Thanks again vbaInet!

Yes, I believe that is what is happening.

vbaInet, Thank you for your response! I am not sure exactly how to use the "Selected" property. I have tried: Me.lst1UnitAlt.Selected(0) = False but I still have to double click on the next listbox. When I use: Me.lst1UnitAlt.Rowsource = "" Then this clears my listbox (which it...

Hi All, I am using Access 2010. I have a form with three listbox. My issue is this, when I go from listbox to listbox the selected item in the previous listbox is still selected. I would like it so when I go to the new listbox, then the previous listbox selection will no longer be...

That did the trick! Thanks JHB!!

Hi all, I am hoping that someone will be able to help me with my problem. I have a report that I am trying to show data for the current year, but with a record count. So, for example: I have 3-OVI, 3-Conduct Unbecoming, and 3-Did not transport for the current year. When I run my report, it...

I was using the code in the Select Case to handle this, but I am guessing that I am very wrong, lol. The only code behind my "Cancel" button is MyAction = Cancel

JHB, Thanks for the response! I do have the forms linked Master/Child. I am not sure why I thought that I needed the ID to show for the data entry. I just didnt know if this would create problems in the long run. I get scared, lol. This one still confuses me. Then why does the...

Hello, anyone out there?

Hi Guys, I have a main form with a suform. The information on the main form is "read only" and the subform is used for data entry. I have a cbo that is used to find personnel and this is located on the main form. When I select personnel with the cbo, this populates the main form fields and...