Search results

Hi, I know this has to be something I'm just overlooking. I've asked a couple people to test out my database. I have a form, where they can click a button that opens another form where they can enter some information. but for 1 user, when they click on the button. The other form 'opens' but...

I've been looking at that, but I must just not have understood it, I was looking at the wrong rows. Grrr. khawar Thank You again for all your help with this

Hi Again, Been trying to modify this just a little, on my real database I have a 'main_form' then a subform, and the drop downs are on a subform of the subform. So I'm trying to duplicate this in the example, and reference the forms correctly, but I can't seem to get it. In the module where...

In the report? I thought I had tried that and it didn't work. I also tried it in the query, the report is based off and didn't work for me there either. oh well, it's working now Thank you for your help.

That looks great! What did you do?

Hi, I've created a report where I've concatenate a field to display the many side into 1 field, using the method found here http://support.microsoft.com/default.aspx?scid=kb;en-us;141624 It's all working great, but I need the items in this field to not appear in alphabetical order, like they...

Thanks! I've been able to get it all working and ordered the way I need it! Thanks to everyone who helped with this. I have another question tho, but maybe I should start a new thread.. Here is my latest test db. Take a look at the report, I'm basically doing the same thing. I believe I...

Thanks, this updates the field afterupdate but I noticed that it doesn't list the comments in the order right order. On the other example I was able to sort the query by accending by the ID of the junction table and that fixed it. I'm guessing I could do it here too? Another issues I...

This gives me a Run Time Error'438' Object doesn't support this property or method'

I'm trying to update a txt field on my main form, with the after update of a combo on a subform. I've tried these in the after update Forms("formmain").Recalc << Doesn't seem to do anything Me.Parent.Recalc << Doesn't do anything Forms("Formmain").Form.Requery <<Requeries the whole form...

ugh, I guess it doesn't quite work the way I want. It requeries the form, but takes you back to record 1 of whatever. How do I just refresh the current record?

OK, got it to work using this on the afterupdate of the combo Private Sub Combo0_AfterUpdate() Forms("Formmain").Form.Requery thanks again for all your help.

Ya I just noticed that myself, I made it in a hurry and didn't realize it until after you had replied. This new version works really well, and not much coding needed either. The only thing I have left to do, is make it so the preview window updates after a selection is made. On the...

Thank You for doing this. It's almost working how I need it too. The only thing I noticed is, since the combo box stores the record ID into the table, the preview box is showing just the ID's. So is that what the query in Pat's is used for? To pull the actual text into the preview?

Thanks for trying to help me with this. Where would this code go?

Ok, I put this in a module correct? YourID= would this be the ID of the main record? Me.txtYourID= Is this the name of the text box on the main form? qYourQuery= what query is this? Then on the main form, I call this on the oncurrent? I'm trying this on a sample db right now. I have...

Hi, This sounds like something that I'm trying to do, would you happen to have a sample db you could post?

Thanks for replying, I've been trying to search for examples of this but haven't found any. Do you know of any examples anywhere, where I can see the code I'm not really sure how to do this.

Hi, Not sure if this is possible, been searching and not seeing any threads with this same request. Here is what I have. On my main form, I have a continuous subform where the user selects some phrases from a dropdown. This text will eventually be used on a report. What I would like to...

Oh lol, Now it makes sense! I just did that, and it worked great. Thanks to both of you!