Recent content by oneidalake

I hope its not poor etiquette to post on such an old thread. I'm using the above solution, but with a bit of a twist. I need to have the dropdown recordsource show 3 years before the current year AND 3 years after the current year. I have it working, but its not sorting the years properly in...

Galaxiom. That did the trick! Thank you so much. I appreciate your help.

Hi Mark The dates are arranged in different areas of the form, so unfortunately, a combo-box would not work. If you look at my original question, my code is giving me the field name instead of the field value. Do you know where I went wrong? Thank you.

Thank you for all the responses. Jdraw, Its basically a scheduler form. You are presented with date fields on a 'calendar' and you select a date by clicking the radio button next to it. Then an append query runs based on that date. The user is only going to select one date before the query...

I have a form with 40 radio buttons and 40 date fields The radio buttons are named Select1,Select2, Select3... The date fields are named d1,d2,d3... Each radio button number corresponds to the date field number. I'm trying to send the value of the date field to a single field called...

Thanks. I was just toying around with something and this one part was driving me crazy. I'll test it out. Although this particular form has quite a few controls (150 or so), I can't imagine adding more than a dozen with this method. Thanks to you both. Jim

Thanks for all the responses. I ended up going with Moke123's suggestion that worked flawlessly! Also, this will be rarely used and will have definite limits. Will only be used in case they need an extra field or two. Thanks again!!! Jim

I have a form with a button that adds a field to another form using vba CreateControl. I want to set the OnGotFocus Event Procedure of that new field. For example, the new field that was created is called test123 within Form "ABC". I want to use vba to create a vba statement for test123 so...

Yes, that did it! Thank you so much. I knew it must be simple. I found a few articles, but nothing worked until YOU! Thanks again!

Hi all, Been wanting to sign up for a long time and now seems like a good opportunity. I would also like to thank you all for being here. Today, I'm trying to figure out something that I think is probably easy. Trying to do a SetFocus when a record is selected. The target control (on...