Recent content by Phonesa

Thanks! Although I switched the order around and went: Form!cbSectionCode = cbSectionCode.Text Form!cbSectionCode.Requery Because when I tried the Requery first, it kept telling me I had to save the field first. Maybe I was doing it wrong the other way though.

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. Back at work and it still keeps crashing. I tried it on another computer and when I click on debub it is saying that it can't find certain files. It only shows part of the path, but it looks like it's trying to find files that were on my hard drive at home! When I hit debug on the...

Ah. Thanks!

Ahh. Thanks. I had it originally declared at the top of my form. :o

Found this thread and I was wondering, once I have declared public variable in my form, do I need to include the module name at the beginning of my form I want to use? Sort of clueless about where to go from here. :confused: Right now I have a module that just declares a public variable but...

Can you post how you got it to work? Thanks.

Speaking of form saving ... is it bad form design to have a form where you have updates to more than one table at once? <whistle> ie Table Defendants: DefendantID , DefendantDetails Table Citations: CitationNo , DefendantID This works for updating existing data, but for new citations where...

Thanks for responding. I forgot to include the DefendantID when I listed the tables. I do have it in my Citations table. :) For whatever reason, the exact version just wouldn't run properly at work today. I had burned a copy of it to take to work this morning. I'll burn another copy and see...

Yeap. I did that. I deleted both controls just in case. I've been backtracking for over 2 hours now tryng to find it. Well, I think I finally found what's causing it and I'm still confused. I had changed the query my form was based on and it's crashing because there is no matching record...

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...

Wayne, I am still getting the same error I'm afraid. When it breaks, it still highlights the same area. I think it's because it's trying to set strCity = NULL If Not IsNull(cbAddress) And cbAddress <> "N/A" Then strCity = DLookup("City", _ <----------------------...

I have an unbound control, txtAddress which I would like to populate depending on my lookup. I'm currently working on a database where each Defendant can have many addresses. They could have 5 different citations against them and all the addresses could be different. I store just the...

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...