Search results

I must be just overlooking something obvious? I should be able to use the same lookup table for those 3 combo boxes right? How do I get the values for the 3 columns to show in a query? Thanks!

Does my example help show the problem I'm having?

here is an example db that I made, I have a form with 3 combo boxes, that use the same lookup table. So my table has 3 columns that get their data from the ID column of the lookup table. Now I'm trying to build a query, that lets me see the actually lookup values and not just the numbers. I...

I think I might be missing something. I have both tables added to the query, I've added all 3 columns in question to the query grid. If I run the query right now, for those columns I just get the lookup numbers from the look up table.

I did, my query has table IRR which holds the records, and the then the lookup table. maybe I'm not building the query right, how would I include the lookups descriptions for all 3 columns?

Hi, I have a table that has 3 columns. Issue, Review, and Information. These 3 fields get their data from the same lookup table that holds some code values. So I'm trying to create a query to export to excel that shows the data for this table, but for the lookup fields, I just get the ID's...

hmm, so what I have should work right? It's not getting me the results that I should be. I have an entry in my database, that has a start date of 2/1/08 and a end date of 2/2/08 In my form, if I put start date 2/2/08 and end date 2/3/08. I'm thinking, it should pull this record, but it...

Hi, If I have 2 date fields (start_date and end_date) And I want o create a query, that captures everything either on or betwen those 2 dates. Would my query be On the start date field. >=[Forms]![frm_PRC_Yes_search]![txt_date_start] Then on the end Date...

cool found the problem! Not sure how this got set in my table, but the default value for the field that my combo box was bound to was set to 0. So every new record was getting 0 put in that field (which I would change when I selected something from the list), so the code was working the whole...

I just created a new form, and inserted the same field names and tried the code and it worked? So there is something on my real form that is stopping it from working. Not sure what. So I'll need to troubleshoot and see what's conflicting with it. I did notice on my test form, the after exit...

Hi, I've been trying to get this to work, but it's not doing what I think it should be doing. If it's a new record, and the cbo has not been selected yet. I want the sub forms to be hidden, but what is happening is they are always appearing when the main form loads. Then what I want it to...

OK, I just dropped it. So overall this should work? Private Sub Form_Current() If cbo_Entered_By & "" = "" Then Me![TabCtl21].Visible = False Me![frm_Member_Appeal].Visible = False Me![frm_Letters].Visible = False Me![frm_PRC].Visible = False Me![lbl_name_select].Visible = True Else...

I like this so much, I'm going to use it on another form, and this time instead of a text box, that is the deciding factor it's on a combo box. On the first part I've changed this If Me.txt_Start_Date & "" ="" Then to If cbo_Entered_By & "" = "" Then << because this is a combo box, does...

That worked great! I was just trying out a if/else type statement when I got the notification that you replied, and I was close to doing what you had. Just missing a few thing :) Thank You!

I'm sorry, but I guess I'm just not understanding what code I need to put on my subforms? I currently have this on my main form Private Sub Form_Current() If Me.NewRecord Then Me![frm_criteria2].Visible = False Me![DX_subform].Visible = False Me![frm_number_incidents].Visible = False End If...

I'm not sure what you mean, which part of the code do I need to put in the form oncurrent? Did you mean the oncurrent of the main form, or each sub form? And how do I call it from the afterupdate of the textbox?

Is there anything I can put on the form's onload, that says if txt_Start_Date is empty, then hide all the subforms. But if the field has data, then make the sub forms visible?

oops, I guess I didn't quite have this completed afterall. I still have the problem if they click on the create new record (which makes the subforms dissappear), and then change their mind and go back to the previous record. The sub forms, don't reappear. I'm thinking I need to put something...

the onlostfocus did it! Thank You!

I also tried it with DoCmd.requery, and that didn't work either. It's really odd, if it's able to hide the forms, it should be able to unhide them. Right? Private Sub txt_Start_Date_AfterUpdate() Me![frm_criteria2].Visible = True Me![DX_subform].Visible = True DoCmd.Requery End Sub