Search results

I thought maybe this would make it work too. Private Sub txt_Start_Date_AfterUpdate() Me![frm_criteria2].Visible = True Me![DX_subform].Visible = True Me.Refresh End Sub but they still don't reappear.

Did you mean something like this, Me.Refresh![frm_criteria2].Visible = True Me.Refresh![DX_subform].Visible = True I tried this, and it didn't work, but wasn't sure if that was what you meant.

Hi, I have a mainform with some sub forms, I want to hide the sub forms until a text box on the main form has been filled in. So I've tried this on my main form Private Sub Form_Current() If Me.NewRecord Then Me![frm_criteria2].Visible = False Me![DX_subform].Visible = False End If End Sub...

I did some more searching around, and found that the bound field needs to be visible for some reason? It doesn't make sense to me, as to why? but I played around with my testdb, and got it to work. I wish there was a way around that, since it adds extra room to the form because of the need...

Does the test DB I posted look OK? Don't see any mistakes that I may have made?

Did you have any luck with getting this to work on a continuous form? The only thing I can think of why it's doing this is because all the records all visible on the form. So when it's told to re-query 'combo 2' it does them all since they are all visible? I hope there is a way around this...

I think people sometimes forget, we can't provide all the information that you would like to see. I would love to post every bit of the DB and all the documentation that I have for you to look at, but I'm not allowed too. So I tried to describe the problem I was seeing with the documentation...

I exported my form, and the tables that it uses to this test db. When you open up the form, make your choices in the first record, and then go to the next record, and make a selection from the first combo. It will erase what you had in second combo of the first record too (it seems to keep...

Well it almost works, but I think this might be the problem with a continous form? When I make a selection for the first record, all is good. Go to the next one and when I make a selection from the first combo, the second combo for all the records go blank. I checked the bound table, and the...

Thanks for the link to yours, I got it to work right off the bat! Thank you!

that got rid of the error, but when I make a choice from the first combo (cbo_criteria), nothing happens in the second one (cbo_subcriteria). It just stays blank.

Do you mean get rid of the entire Select Distint statement? where I would have this Me.cbo_subcriteria.Requery = "tbl_criteria_sub_lookup.Criteria_Sub_Options, tbl_criteria_sub_lookup.ID FROM tbl_criteria_sub_lookup WHERE tbl_criteria_sub_lookup.Criteria_dropdown_ID = '" & [cbo_criteria] & "'"...

I tried changing it to, .Requery = "SELECT DISTINCT tbl_criteria_sub_lookup.Criteria_Sub_Options, tbl_criteria_sub_lookup.ID FROM tbl_criteria_sub_lookup WHERE tbl_criteria_sub_lookup.Criteria_dropdown_ID = '" & [cbo_criteria] & "'" and I get the same error.

OK, I gave that a try but when I update field 1, it gives me an error Compile Error, Expected Function or variable Here is my code, I think I did it right? Private Sub cbo_criteria_AfterUpdate() With Me.cbo_subcriteria .Enabled = True 'This code is very popular and uses the...

Where should I put the requery? here is my complete afterupdate event Private Sub cbo_criteria_AfterUpdate() With Me.cbo_subcriteria .Enabled = True 'This code is very popular and uses the double quote (") as a delimiter in the SQL statement. 'It also functions in the...

Thanks for the tips on the warning, I'll check that out right now. I've been working on this db all week, and it probably did warn me, but I was just so tired of messing with it, I didn't realize what I did. back to the combos, I'm not sure what I'm doing wrong here, maybe it doesn't work the...

Hmm, I'll have to take another look. Now that you said that, it makes sense. Edit: Just took a look and the first field wasn't bound anymore!! Maybe I didnt' save the form, the last time I closed it but I sure thought it was bound.

That's pretty cool, I'm going to play around with it, and see if I can make it work for what I need. Thanks!

OK, got the bounding problem to work, but now here is my next problem. I want to use these on a continuous form, but now I just realized that when you update record 1, it updates all the records in the form. I searched the form, and found this to be a problem but in one post Pat said he found...

Hi, I search the forum, and also read the cascade FAQ, but didn't see this answer. I want to have some cascading combo boxes, but all the examples I see have the cbo's as unbound. I would like to have mine bound, so when the make a selection from each cbo, it's saved in the table? Is this...