Search results

Here is the Database...to duplicate the problem do this...Click on add incident, fill in the controls on the new form that opens andthen click on"Add Incident" . Then select the new incident you added and then the name in the second listbox....the data gets filled in when it should be blank!

Maybe I should give more information. I have two tables- tblOffense and tblName. tblOffense has all of the pertinent information. There are several records in tblOffense that have the same LogNum (one for each name). The first listbox is populated with a DISTINCT query of tblOffense. The second...

I have a form that has cascading listboxes. The first one lists incident numbers and the second one is for names that are associated with the selected incident number. The form has textboxes that are populated via code from the query on the second textbox. I have a command button to add incident...

That creates a problem....I used a combobaox and limited it to the list....works fine!

I have a listbox and I am not sure how to reference the information that is showing in the box. You can select an item but then scroll to another item...I want to use the data that you can see in the list box. I have tried lstEthnic.Column(0) lstEthnic.ItemData.... I have searched and can't find...

From my understanding the OnDirty event is only for forms with bound fields. I have a form with several unbound textboxes for data entry. What I would like to do is to find out if any of the textboxes have been altered, if so, then save the data....any suggestions?

Not being sure of exactly what you have, here is a suggestion. You can create an on update event for the combo boxes and then populate the subform in this event (or requery if the subform is based on a query)

I have a form that has cascading listboxes. The first one lists incident numbers and the second one is for name that are associated with the selected incident number. The form has testboxes that are populated via code from the query on the second textbox. I have a command button to add incident...

That was the problem!!! Thanks a million!

??? I tried this and I got a Next without for error.. I am not sure why. Here is the code: Private Sub lstLogNum_AfterUpdate() Dim vItem As Variant DoCmd.GoToRecord , , acNewRec For Each vItem In Me.Controls If TypeOf vItem Is TextBox Then vItem.Value = "" End...

Thanks....Worked GREAT!!!! I changed the field to LogNum

Thanks...I will try this. I want to incorporate saving fields as well so I am going to try this Public Sub check_type() Dim vItem As Variant Dim iCount as integer iCount=1 For Each vItem In Me.Controls If TypeOf vItem Is TextBox Then rs.fields(icount)=me.controls.text...

I am not sure how to do what you suggest.... the list box source is a query SELECT DISTINCT tblOffense.[Log#] FROM tblOffense; I am not sure how to add a column to a query.. A query is just a filter isn't it? I tried SELECT DISTINCT tblOffense.[Log#] FROM tblOffense, Sorted:Right(Log#,6)...

I have on problem and one curiosity. The first problem I have is that I have 2 listboxes, sort of like cascading listboxes. You select a record in the first listbox and the second listbox is generated from the criteria in the first listbox. The problem I have is that when you add a new incident...

I guess I wasn't clear...The data is stored as AAA-AAA-YY-MM-#### format (With or without the dashes, I can work around the dases) I have not stripped the first characters, it is stored in the entire format. I have a feeling that I am going to need to store each section in a different field, and...

The info is in one string. How do I split the string into columns in the listbox?

I have a listbox that I need sorted and I am not sure how the best way would be. The problem is the format of the data that I need to sort. The data is in the form AAA-AAA-YY-MM-1234 where AAA is misc. letters, YY is the year, MM is the month, and 1234 is an identifying number. I need to sort...

Thanks That worked...so what other issues do you see? I would like to correct them before I get too far into this project. Thanks in advance

A little clearer From the results I was getting I assumed that the data was not really there...I wasn't sure at what point it was available. Using the acDataErrAdded would probably work. I changed the bracket and added the acDataErrAdded. The combobox still did not have the data...grrrrrr. When...

clarification I tried your suggestion but it didn't work. I tried variations but is still didn't work. I don't think I was clear in what I was doing, hopefully this makes it a little clearer. The combobox on frmAddInmate (cmbCDCAdd) has a row source of all inmates previously involved in an...