Search results

Right now, if a user enters an item not in my combo box, I open a form which lets them add the item to the box in the NotInList event. After I enter it though, I still have to manually go down and find the item in my combo box or else it keeps telling me that the item is not in the list! In a...

Well. What can I say? I'm so confused right now. As soon as I try and tab out of my text box, I keep crashing. It's always the same control, too. The weird thing is, I have no code in there at all so I'm totally stumped. :( I feel like banging my head on my desk atm. I don't suppose...

if the results are not found. How can I set it up so that it does not give me "invalid use of null" error? My code looks like this: If Not IsNull(cbAddress) And cbAddress <> "N/A" Then Dim strState As String Dim strCity As String Dim strZip As String...

I have a form, CitationInfo, which is based off of say 2 tables, DefendantInfo(defendantid , defendantinfo) and Citations(citationno defendantid, citationdetails). If the defendant already exists in my DefendantInfo table, no problem. However, if this is a new defendant, I am getting an error...

I have 3 tables: Aliases: DefendantID, Alias Defendant: DefendantID, Name Citations: CitationNo, DefendantID, CitationDetails I created two queries and they sort of work ... 1) In my first query, I do a union between Aliases and DefendantID to get all the DefendantIDs for a defendant...

I have a form with a subform on it. I have made it so the form can't be edited unless the user clicks my Edit button. So far, in my Edit button on click event: me.allowedit = true This allows me to edit my main form, but my subform remains uneditable. Help please!

Hi, I'm hoping some of you migh have some suggestions. I have 3 tables: DefendantInfo: DefendantID, Defendant Name Address: AddressID, DefendantID, and Address (each defendant can have more than one address) Citations: CitationNo, DefendantID, AddressID Currently I've got my Address table set...