Problem accessing control in another form

hello,

I have 2 forms one for basic stock item details and the other is the vb calender.

When clicking the calender i would like it to populate my combobox "date1.text".

when i am in my stock item form and i'm editing code i can press ctrl+spacebar and it will give me a list of valid objects (including my date1 box) but when i am editing the calender code all the boxes from my other form aren't there.

Ultimately, when running the calender with "date1.text" in the code, there are errors.

I am sure this is a schoolboy error and would appreciate some education!!

thanks in advance for your help

John

Hi John,

Do you have a reason for not putting the Calendar control in the same form
as the ComboBox?

Assuming that you do, in the Userform2's Calendar click event, add :

UserForm1.Date1.Value = Me.Calendar1.Value


---
Regards,
Norman



"johncassell" <[email protected]>
wrote in message
news:[email protected]...
>
> hello,
>
> I have 2 forms one for basic stock item details and the other is the vb
> calender.
>
> When clicking the calender i would like it to populate my combobox
> "date1.text".
>
> when i am in my stock item form and i'm editing code i can press
> ctrl+spacebar and it will give me a list of valid objects (including my
> date1 box) but when i am editing the calender code all the boxes from my
> other form aren't there.
>
> Ultimately, when running the calender with "date1.text" in the code,
> there are errors.
>
> I am sure this is a schoolboy error and would appreciate some
> education!!
>
> thanks in advance for your help
>
> John
>
>
> --
> johncassell
> ------------------------------------------------------------------------
> johncassell's Profile:
> http://www.excelforum.com/member.php...o&userid=25016
> View this thread: http://www.excelforum.com/showthread...hreadid=391689
>

Thanks for the reply Norman, I havent tried that code yet but sure it will work. I have a combobox which hopefully will call the calender when the drop-down button is clicked, I assumed that the calender had to be a separate form. Am i right in thinking this?

Thanks again for the reply

Hi John,

> I assumed that the calender had
> to be a separate form. Am i right in thinking this?

No. Given your description, I would only use a single form.

If you use a single form, the code line becomes:

Me.Date1.Value = Me.Calendar1.Value

---
Regards,
Norman


"johncassell" <[email protected]>
wrote in message
news:[email protected]...
>
> Thanks for the reply Norman, I havent tried that code yet but sure it
> will work. I have a combobox which hopefully will call the calender
> when the drop-down button is clicked, I assumed that the calender had
> to be a separate form. Am i right in thinking this?
>
> Thanks again for the reply
>
>
> --
> johncassell
> ------------------------------------------------------------------------
> johncassell's Profile:
> http://www.excelforum.com/member.php...o&userid=25016
> View this thread: http://www.excelforum.com/showthread...hreadid=391689
>

Yes that worked Norman... cheers , however I have a small problem. After the calender has put the date in my date box and i press enter, the calender pops up again, it also pops up if i use the mouse to move to the next box.

Can you help with this please??

Thanks again for replying

Hi John,

Post the userrform code.


---
Regards,
Norman



"johncassell" <[email protected]>
wrote in message
news:[email protected]...
>
> Yes that worked Norman... cheers , however I have a small problem. After
> the calender has put the date in my date box and i press enter, the
> calender pops up again, it also pops up if i use the mouse to move to
> the next box.
>
> Can you help with this please??
>
> Thanks again for replying
>
>
> --
> johncassell
> ------------------------------------------------------------------------
> johncassell's Profile:
> http://www.excelforum.com/member.php...o&userid=25016
> View this thread: http://www.excelforum.com/showthread...hreadid=391689
>